Help Center

Import: Merge files - Making A Google Sheet Public

Sarah Bacchus
Sarah Bacchus
  • Updated

Make Google Sheet public

Once you have created your data file and are ready to merge, you will need to publish your Google Sheet to a CSV file in order for our system to bring in the updated changes at the next scheduled import time.  Please see the following steps below on how you can make a Google sheet public:

 

googlesheets5.PNG

  1. In Google Sheets, go to File > Publish to the web
  2. Select “Entire document” and “Comma-separate values (.csv)”
  3. Under “Published content and settings” dropdown menu, check the “Automatically republish with changes are made” option
    • This means then you make changes to the sheet they are immediately ready to be imported by our system. Once you make a change to your merge file in Google Sheets, simply run a new product import in GoDataFeed. Otherwise, the changes will be imported at the next scheduled time.
  4. Lastly, (starting 11/18/20, you will also need to make the Sheet public) click the "Share" button
    mceclip0.png
  5. Under the "Get Link" section choose "Anyone with the link" - note, the view, edit permission don't matter in this case because we are simply getting an export .csv of the data not using the web browser.
    mceclip1.png
    • This will allow our system to download the data.
  6. You are all done - to confirm the share settings are correct, you should now see "Anyone with the link" or in the top-right corner you should see the Share button with a link icon.

mceclip2.png

mceclip4.png

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.