So basically I have a Google Sheets Document that is shared with our recruiting department (they love GSheets for some reason), and they are continually updating as they are resourcing and hiring candidates for various projects.
What I am trying to do is have a similar Table in Airtable to mimic or mirror the data from that GSheet, and also as new rows are created it creates a new row in Airtable. I feel like this should be fairly simple, but I can only get it to add lines as new rows are created in GSheets, and not monitor and update existing rows.
Any help is greatly appreciated. Thanks!