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.
Select Add for the Google Sheets data source.
(Optional) 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. In the Authentication drop-down menu, choose between:
The default Productsup Authentication. This option creates the sheet under Productsup’s Google Drive, and you receive a public link to edit your data.
Your Google account within Productsup, if you have previously authenticated it. See Add OAuth authentication to external systems. The platform creates the sheet under your Google Drive.
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 platform generates the link to the Google spreadsheet which appears in the Source URL field.
Select Open Spreadsheet and add your data in it.
(Optional) Enter or edit your data source 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. For that:
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 that you enabled the Viewer rights for anyone who opens the link. See Share files from Google Drive.
Import the first worksheet in your Google Sheet
To import the first worksheet:
Go to Data Sources from your site's main menu and select ADD DATA SOURCE.
Select Add for the Feed URL data source.
(Optional) 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.
Edit your link so the format looks similar to
https://docs.google.com/spreadsheets/d/{key}/export?format=csv
where:{key}
- a variable set of numbers and letters, which defines your sheet. You can find thekey
after/d/
in the URL of the spreadsheet or by selecting the Share button in the Google Sheet.
Select Save.
Import a definite worksheet from your Google Sheet
To import a sheet other than the first one, you should:
Go to Data Sources from your site's main menu and select ADD DATA SOURCE.
Select Add for the Feed URL data source.
(Optional) 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.
Edit your link so the format looks similar to:
https://docs.google.com/spreadsheets/d/{key}/export?format=csv&gid={gid}
where:{key}
- a variable set of numbers and letters found in the URL, which defines your sheet.{gid}
- a unique ID for the worksheet, defined by Google.
Select Save.
Import certain cells from your Google Sheet
Go to Data Sources from your site's main menu and select ADD DATA SOURCE.
Select Add for the Feed URL data source.
(Optional) 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.
Edit your link so the format looks similar to:
https://docs.google.com/spreadsheets/d/{key}/export?format=csv&gid={gid};range={range}
where:{key}
- a variable set of numbers and letters found in the URL, which defines your sheet.{gid}
- a unique ID for the worksheet, defined by Google.{range}
- the cells you want to import.
Select Save.