Skip to main content

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:

  1. Create a new sheet via the platform.

  2. Import from an existing sheet.

Create a new Google Sheet via Productsup

To create a new Google Sheet via Productsup:

  1. Go to Data Sources from your site's main menu and select ADD DATA SOURCE.

  2. Select Add for the Google Sheets data source.

  3. (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.

  4. 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.

  5. Select Create Spreadsheet. The platform generates the link to the Google spreadsheet which appears in the Source URL field.

  6. Select Open Spreadsheet and add your data in it.

  7. (Optional) Enter or edit your data source name in Description.

  8. Select Save.

    The Create Spreadsheet button

Update a spreadsheet created via Productsup

  1. Go to Data Sources from your site's main menu and select the cogwheel icon () next to the relevant data source.

  2. Select Open Spreadsheet and make the necessary updates.

    The Open Spreadsheet button

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:

  1. Go to Data Sources from your site's main menu and select the cogwheel icon next to the relevant Google Sheet data source.

  2. Choose the necessary worksheet in the Worksheet drop-down menu.

  3. Select Save.

    Choose a necessary worksheet in the Google Sheet

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:

  1. Go to Data Sources from your site's main menu and select ADD DATA SOURCE.

  2. Select Add for the Feed URL data source.

  3. (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.

  4. Insert the link to your Google Sheet in Source URL.

  5. Edit your link so the format looks similar to https://docs.google.com/spreadsheets/d/{key}/export?format=csv where:

    1. {key} - a variable set of numbers and letters, which defines your sheet. You can find the key after /d/ in the URL of the spreadsheet or by selecting the Sharebutton in the Google Sheet.

  6. Select Save.

    Feed editing - Google Sheet Url key

Import a definite worksheet from your Google Sheet

To import a sheet other than the first one, you should:

  1. Go to Data Sources from your site's main menu and select ADD DATA SOURCE.

  2. Select Add for the Feed URL data source.

  3. (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.

  4. Insert the link to your Google Sheet in Source URL.

  5. Edit your link so the format looks similar to: https://docs.google.com/spreadsheets/d/{key}/export?format=csv&gid={gid} where:

    1. {key} - a variable set of numbers and letters found in the URL, which defines your sheet.

    2. {gid} - a unique ID for the worksheet, defined by Google.

      gid.png
  6. Select Save.

Import certain cells from your Google Sheet

  1. Go to Data Sources from your site's main menu and select ADD DATA SOURCE.

  2. Select Add for the Feed URL data source.

  3. (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.

  4. Insert the link to your Google Sheet in Source URL.

  5. Edit your link so the format looks similar to: https://docs.google.com/spreadsheets/d/{key}/export?format=csv&gid={gid};range={range} where:

    1. {key} - a variable set of numbers and letters found in the URL, which defines your sheet.

    2. {gid} - a unique ID for the worksheet, defined by Google.

    3. {range} - the cells you want to import.

  6. Select Save.

    Define the Google Sheet range