This tutorial walks you through how you can extract the data from tables in multiple Google Docs and combine into one structured table in Coda to sort, filter, and organize your Google Docs. The script uses Google Apps Script to do the sync. To read the full tutorial and howto for this script, please go to this post: https://coda.io/@atc/howtoextractd...

Easily jump to sections in this video:
Intro 0:00
Create Google Drive folder with Google Docs 0:26
Structure of tables in Google Doc 1:04
Create Coda table with same columns 1:46
Add "Google Doc Link" column 2:10
Add in your API key 2:41
Add in your Coda doc table ID 3:34
Add in your Google Drive folder ID 4:38
Click the runSync function 5:07
Add a new Google Doc to the Google Drive folder 7:09
Only data from new Google Docs are synced over to Coda 7:59
Cannot sync over hyperlinked text 8:35

If your organization creates multiple Google Docs every day and you want a better way to sort, filter, and organize all these Google Docs, this solution may be useful for you. This tutorial walks you through how to extract the important metadata from a table in a Google Doc and sync that data into a table in Coda.

I often see templates for project briefs, meeting notes, or candidate interview as Google Docs at other organizations which are duplicated over and over again. These Google Docs are then stored in Google Drive which can get very unwieldy to manage unless someone is consistently organizing the folders in Google Drive. Another common trait in these Google Docs: a table near the top of the Google Doc summarizing what the doc is about.

Some of the resources mentioned in this tutorial:

Full post about this script: https://coda.io/@atc/howtoextractd...
Script in GitHub: https://gist.github.com/alcodaio/36f...
Community thread: https://community.coda.io/t/extractd...

▶ Follow the Coda blog: https://blog.coda.io
▶ Join the Coda community: https://community.coda.io