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?
May 16, 202304:18 AM - edited May 16, 202304:19 AM
The easiest, quickest, low-code/no-code way of doing this is to use Make. There can be a bit of a learning curve with Make, which is why I created this basic navigation video for Make, along with providing the link to Make’s free training courses. There are also many Make experts hanging out there who can answer other Make questions.