I use Airtable for something related to website data. I have a table which is a list of pages/URLs from a website, which was extracted from Google Analytics. The key is the URL/page but it also contains data such as the volume of page views and other statistics about the page.
In an ideal world I want this table to update automatically, so e.g. the data is always about the most recent month.
I know there is a zapier integration but I can’t get my head around it, mainly because what happens if someone creates a new page in the source data i.e I am not just updating records based on changes to the data in Sheets, I need to also populate new records. Is this multiple Zapier integrations??