Import from Google Sheets

Import product feed data from Google Sheets in Productsup.

To import your data from Google Sheets, you can either create a new sheet via the platform, or import from an existing sheet.

Create a Google Sheet via Productsup

Note

When deleting the Google Sheets data source from the platform, the sheet will be moved into the trash of the Google account it is hosted in.

You will only be able to restore if you have set the authentication to use your own Google account (see step 7).

  1. Navigate to your site

  2. Navigate to Data Sources

  3. Click add data source

  4. Add the Google Sheets data source

  5. Give your data source a specialized name (if desired)

    1. This will replace the name of the data source option on the data sources overview page

  6. Click Continue

  7. You can select authentication under the drop-down menu (optional)

    1. if you do not select any authentication and use the default Productsup Authentication, the sheet will be created under Productsup’s Google Drive.

      1. you will receive a public link to edit your data

    2. if you have authenticated your Google account within Productsup, you can select this under the authentication dropdown

      1. the sheet will be created under your own Google Drive

      2. for information about how to authenticate a Google account in Productsup, see Add OAuth authentication to external systems.

  8. Click Create Spreadsheet, which will generate a sheet for you

    1. then click open spreadsheet and add or copy/paste your data into it

  9. Add a description (if desired)

    1. This is another chance to add a specialized name (see step 5)

  10. Click Save

    adding_sheet.png

Update a spreadsheet created via Productsup

To update a sheet you created, you can:

  1. Navigate to your site

  2. Navigate to Data Sources

  3. Click on the settings wheel of the relevant Feed URL data source to open up advanced settings

  4. Click on Open Spreadsheet

    open_sheet.png

Alternatively, you can save or bookmark the direct link to the sheet and access it in this manner.

Select a different worksheet from a spreadsheet created via Productsup

  1. Navigate to your site

  2. Navigate to data sources

  3. Click on the settings wheel of the relevant Feed URL data source to open up advanced settings

  4. Input the sheet to import in the worksheet field

  5. Click Save

Import from an existing Google Sheet

If you already have a Google Sheet with your data, you can also import this directly into the platform.

Note

In order to import from an existing Google Sheet, you need to ensure that read access is available for every person who clicks on the link. If you’re not sure how to do this, see Google's Share files from Google Drive.

Importing the first worksheet in your Google Sheet

To do import the first worksheet, you should:

  1. Navigate to your site

  2. Navigate to Data Sources

  3. Click add data source

  4. Add the Feed URL data source

  5. Give your data source a specialized name (if desired)

    1. This will replace the name of the data source option on the data sources overview page

  6. Click Continue

  7. Enter the link to your Google Sheet in Source URL

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

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

  8. Click Save

    entire_sheet2.png

    Tip

    The Google Sheet key is a long sequence of characters. It is normally found in the key attribute of the URL, or after /d/  in the URL of the desired spreadsheet. You can find the spreadsheet key by clicking the Share button in the URL.

Import a defined worksheet from your Google Sheet

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

  1. Navigate to your site

  2. Navigate to Data Sources

  3. Click add data source

  4. Add the Feed URL data source

  5. Give your data source a specialized name (if desired)

    1. This will replace the name of the data source option on the data sources overview page

  6. Click Continue

  7. Enter the link to your Google Sheet in Source URL

    1. edit your link so that the format looks like: https://docs.google.com/spreadsheets/d/{key}/export?format=csv&gid={gid}

      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
  8. Click Save

Import certain cells from your Google Sheet

  1. Navigate to your site

  2. Navigate to Data Sources

  3. Click add data source

  4. Add the Feed URL data source

  5. Give your data source a specialized name (if desired)

    1. This will replace the name of the data source option on the data sources overview page

  6. Click Continue

  7. Enter the link to your Google Sheet in Source URL

    1. edit your link so that the format looks like https://docs.google.com/spreadsheets/d/%7Bkey%7D/export?format=csv&gid=%7Bgid%7D&range=%7Brange%7D

      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

  8. Click Save

    range2.png