I have created a feedback form within one of my Airtable bases that is collecting data about different facilitators. I have set up multiple automation’s to funnel the information into a google sheet for the individual facilitator but when I test it seems that the data from the form is populating a row in the multiple google sheets at the same time.
A new record is created (submission through the form)
Find records - I have put in a condition for the automation to find records where it contains a particular name within the Facilitator Name field in the form.
Append a new row in a Google Sheet - I have selected the spreadsheet for the specific individual. The row data is selected and working properly.
Sends an email through Gmail to notify the individual that they have new feedback.
Has anyone come upon this type of thing before? Am I missing a step?