In Airtable i have students information including a unique student ID for 600 students in a view called Master class showing students from Pre-K to grade 4.
I need the 600 students data information to sync with z Google sheet.
I have created a scenario using MAKE (aka integromat) and I can
- Create a new line in Google sheet if a new student is added to Airtable
- update the values in Google sheet if they are updated in Airtable
The tricky part was if a value is deleted in Airtable (student is leaving Learning Support, a box is unchecked in Airtable) as the update formula was not clearing the respective cell in Google sheet but I was able to work around. So this work too.
The last thing I cannot find a way to do is :
If a student is deleted in Airtable or is not visible in the master class view because the student grade is now grade 5 for example, Ineed to delete the same student row in Google sheet. And I cannot find a way to do it.
My idea was every x minutes in integromat to compare all the student ID IN AIRTABLE, then all the students ID in Google and if one was missing in Airtable then delete the row in Google sheet but I cannot make this work.
Any idea ? Using integromat or the sortable sync feature ?