3

I have data in a Google docs spreadsheet. To import that data I currently have to download the spreadsheet as a csv file and then import using the Feeds module.

What I am trying to work out is if there is someway to automate the process? Is there some way to have feeds access the spreadsheet directly from Google docs?

Would appreciate some step by step instructions on how to set this up. Note that I already have feeds setup to manually import a csv file, so the issue at hand is how can I set it up so that feeds can retrieve the data directly from Google docs at regular intervals?

Note that the data is stored as regular Google doc spreadsheet, so solution needs to make sure that the document retrieved is in CSV format (is that possible by using a certain URLs structure?)

1 Answer 1

6

Sorry, bit late to the party. How I solved this was:

  • Publish the file to the web using the option in Google Sheets' file menu. This gets you a special link to an always up-to-date version with the format of your choice. I used CSV.
  • Select HTTP fetcher as fetcher.
  • Select appropriate parser (CSV in my case) and set up mapping
  • Set up periodical imports.
  • Enter the URL you got from Google Sheets as source when importing.

Your updates to the Google Sheets file will be imported with the periodical imports.

2
  • Thanks for the answer. For security purposes, is there a way to ensure that only the website in question can access the data from Google docs?
    – Benjen
    Jan 19, 2017 at 18:43
  • 1
    Google Sheets produces a link with a unique character sequence in it, so if you don't share that link anywhere else, no one will have access to it. Should be secure enough.
    – Dr. Gubó
    Mar 15, 2017 at 8:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.