Hi @onetail
To help us have more context, post screenshots with how your Zap steps are outlined and configured.
You’ll likely need to use the Looping app to handle 1+ line items: https://zapier.com/apps/looping/help
I tried to do the following. Where I am having an issue is that I their is a new workbook with a new file name loaded each day. So for step 2 and 3 it would just pull from the first workbook loaded.
- Trigger: New Worksheet in Google Sheets
- Action: Lookup Spreadsheet Rows (Line Items) in Google Sheets
- Action: Create Loop from Line Items in Looping by Zapier - please note this is only optional if you have multiple rows from the new worksheet that you want to pass to Mailchimp
- Action: Add/Update Subscriber in Mailchimp
Hi there, @onetail!
Ah, it’s only pulling from the first workbook that’s loaded as the New Worksheet trigger would only trigger when a new worksheet is added to the specific spreadsheet/workbook that’s been selected in the Zap.
As it’s generating a new spreadsheet/workbook file then perhaps the New Spreadsheet (Google Sheets) or New File in Folder (Google Drive) triggers might work better for your desired workflow here. Both of those triggers should see the new file that’s added.
Can you give either of those a try and let us know how you get on?
I realized I should have said I do that already.
- Trigger: New email in email parser
- Action: Upload file in Google Drive
This is where I get stuck and don’t know how to take the data from that new file and put as new worksheet in existing workbook. There isn’t a single lookup value. I am hoping there is a way that when a new file is loaded in the google drive folder it takes the worksheet from that file and places it in existing file as new sheet. I then hope I can create a trigger for when that new sheet is created to get it to update MailChimp.
In general, I am trying to figure out the best way to create Zaps that enable me to take data from an emailed report that comes in as a link and get the data from those reports.
Thank you!
Hi @onetail
You may have to explore using the GSheets API via one of these advanced actions:
- Custom Action
- API Request