So, I'm using the Google Docs API to extract spreadsheets programmatically.
However, I'm only interested in spreadsheets which are live feeds from form responses (survey responses). Is there a way of detecting this? So far the only approach I have is that the spreadsheet has a 'Form Responses 1' tab, which is quite a long way into the process; ideally I'd like to know before I download the file.
I'd be overjoyed by solutions which start with the form and tell you the relevant spreadsheet; ones which verify if a spreadsheet is a form's output are okay; knowing it's impossible would be helpful.
It is possible to get a list of the worksheets by using the Spreadsheets API.
Here is a link to the relevant documentation.
https://developers.google.com/google-apps/spreadsheets/#retrieving_information_about_worksheets
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments