API Data Set Instructions for Google Sheets (Advanced)
I know that the advanced license has an API data set feature, but for the life of me I can't figure out a way to use it to connect to Google Sheets.
This would take our reporting to the next level since the formula list for reporting is scanty compared to what someone proficient with excel / and google sheets query can do.
Currently aggregating across columns is a major pain (especially if some rows don't have data in them) and creating one unified list if you have multiples of something in the same form (e.g. Event 1, Event 2, Event 3 and you need one column of all events) is nigh impossible inside the reporting tool.
I'm sure it would be useful to more than just me and there's got to be a way to do it but I'm not good enough at coding to figure out how.
Meg Hillmann
shared this idea
-
Andy M
commented
This would be a huge help for us. Currently use reports to extract raw data. Copy 8 or so report data sets to Excel to do analysis of our grants. Any changes to to the grants requires a complete refresh of reports, copy, paste back to excel. Quite cumbersome. Any instructions out there on how to use the API with google sheets?