A Coda user needed a solution to aggregate the data stored in multiple Google Docs into one table in Coda for easy sorting and filtering, so I wrote a Google Apps Script that does the following:
- Checks a Google Drive folder for any new Google Docs that have been added to the folder
- Takes the first table in the Google Doc and extracts the info
- Sends the data to a row in a Coda table along with the Google Doc link
- Accounts for Google Docs that are shortcuts to a Google Doc owned by someone else
Also wrote a blog post and video tutorial on how to use the script.