I have a spreadsheet (can be in google sheets or excel) that has 529 rows. One of the columns is a unique identifier alpha numeric number. There can be multiple rows for each of the unique identifier. There is an email address in a column associated with each of the identifiers.
I need an action that grabs all rows with the unique identifier and emails all rows as one email to the email address listed using Gmail.
Any thoughts on how to do this with Zaps?
Thanks
+14
Hi
Good question.
Here’s what I’d recommend...
Convert the GSheet to an Airtable Base: https://zapier.com/apps/airtable/integrations#triggers-and-actions
You can then link multiple email records to 1 unique ID record.
That way when you find the record with the unique ID, it can be configured to return the linked emails.
I didn’t explain myself well. Here’s my example data - I need 1 email sent per ID but the email needs to contain the data from multiple rows
+14
GSheet has some options to find multiple rows, but there are limitations:
Otherwise, the recommendation for converting your GSheet to Airtable would be another approach ton consider for your use case.
Hey
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
