You are here:  » Google sheets API now requires key also for public sheets

Active Forum Topics


Google sheets API now requires key also for public sheets

Submitted by Goodconcepts on Mon, 2020-09-28 13:46 in

Hey David,

Some of my feed data is obtained from spreadsheets maintained manually in Google sheets.

The google sheets API was working fine in the automation tool for public sheets that do not require authentication, but recently the feed stopped working as Google has added API key as minimum authentication method for public sheets as well.

I have created an API key in google but how do I now use the key in the automation tool and/or cron.php ?

Regards,

Denis

Submitted by support on Tue, 2020-09-29 07:49

Hi Denis,

Could you let me know an example of the URL that was previously working with the Automation Tool (change google.com to example.com and just example IDs in the URL) and what would also help if there is a specific API documentation page that shows how to authenticate and download the file now that an API key is required i'll check it out for you - it might just require a simple filter script so that the Automation Tool points to a script on your server that makes the request to the sheets API...

Cheers,
David.
--
PriceTapestry.com