I have a table called contracts and I have 200 google sheet spreadsheets representing each contract.
I can import/sync to Airtable from a Google sheet but I only want 1 row per contract (200 rows total), and I want the fields to map to specific spreadsheet values. I also need this to work for future contracts where I can insert a URL of the latest signed contract into a new row and Airtable will automatically extract the data from the spreadsheet for me.
I was thinking the best way to do this was probably with an automation + script, but I'm struggling to even read data using Google's rest api using Airtable's script language (these contracts aren't shared publicly so I need to handle authentication which is proving tricky in Airtable's scripting language)
Has anyone done something similar themselves? Or perhaps someone has a better method to achieve the same result?