Import from Google Sheets
Learn how to import product feed data from Google Sheets to Productsup.
Introduction
A Google Sheet is a spreadsheet file created and edited online in Google Workspace.
You can import your data from Google Sheets in two ways:
Create a new sheet via the platform.
Import from an existing sheet.
Create a new Google Sheet via Productsup
To create a new Google Sheet via Productsup:
Go to Data Sources from your site's main menu and select ADD DATA SOURCE.
Search for Google Sheets and select Add.
Optionally, give your data source a custom name. This custom name replaces the name of the data source on the Data Sources Overview page. Then, select Continue.
The Source URL field remains empty. For the authentication choose between:
Continue with Productsup Authentication and let the platform create a sheet under Productsup’s Google Drive, providing you a link to the sheet where you can edit your data.
Warning
The platform creates a Google Sheet with public access rights via URL. This is necessary to let the platform freely import your data.
Select Add New Authentication and let the platform create a sheet in your Google Drive account that you have previously authenticated in Productsup. See Add OAuth authentication to external systems.
Note
Deleting the Google Sheets data source on the platform moves the data source into the trash of the Google account.
You can restore it if you have set the authentication to your Google account.
Select Create Spreadsheet. The link to the Google spreadsheet appears in the Source URL field above.
Select Open Spreadsheet and add your data to it.
Optionally, give your data source a custom name in Description.
Select Save.
Update a spreadsheet created via Productsup
Go to Data Sources from your site's main menu and select the cogwheel icon (⚙) next to the relevant data source.
Select Open Spreadsheet and make the necessary updates.
Alternatively, you can save or bookmark the link to the sheet and access it directly.
Select a worksheet from a spreadsheet created via Productsup
If your sheet consists of several worksheets, you may specify which one you want to import.
Go to Data Sources from your site's main menu and select the cogwheel icon ⚙ next to the relevant Google Sheet data source.
Choose the necessary worksheet in the Worksheet drop-down menu.
Select Save.
Import from an existing Google Sheet
If you already have a Google Sheet with your data, you can import it directly into the platform.
Note
Ensure to enable the Viewer rights for anyone who opens the link. See Share files from Google Drive.
Go to Data Sources from your site's main menu and select ADD DATA SOURCE.
Select Add for the Feed URL data source.
Optionally, give your data source a custom name. This custom name replaces the name of the data source on the Data Sources Overview page. Then, select Continue.
Insert the link to your Google Sheet in Source URL.
Note
To import the first worksheet, copy and paste the link to the first worksheet.
To import a sheet other than the first one, you should edit the link in the Source URL field by changing the gid parameter that you can find at the end of the link of the necessary sheet.
{gid}is a unique ID for the worksheet, defined by Google.
To import certain cells from your Google Sheet, edit the link in the Source URL field by changing the current gid to gid of the necessary worksheet and defining the cells you want to import in the range parameter. You can manually enter the range after gid in the format
range=A1:D15
Select Save.