Automatically import data from Google spreadsheet using feeds module
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.