I want to create an automation with Zapier AI, and I want to do this in a single process. I have five different Google Sheets, and I have a query table in Zapier that includes the variables from these datasets I prepared earlier. What I want to do is:
- Transfer data from these five Google Sheets to my query Zapier table.
- When a new data row is added to these datasets, I want my Zapier table to be updated; therefore, I want the datasets to be checked daily at 8 AM.
- Since there are people with the same names in these five different datasets, I want the relevant people's data to be on the same row in my Zapier table.
- When I use the "Get Many Rows" operation, it reduces all the data in one column to a single row, so the data cannot be separated correctly, and I cannot create new spreadsheet rows with the "Every Day Schedule by Zapier."
- How can I solve this in a Zap process?