Skip to main content

I’m trying to create a zap that collects data from a list in sheets and inserts that data into an email in outlook when a separate google sheet is updated OR when a stripe charge is received, either is a good trigger.

Can you please clarify your question?

Stripe triggers: https://zapier.com/apps/stripe/integrations#triggers-and-actions

GSheet triggers: https://zapier.com/apps/google-sheets/integrations#triggers-and-actions


Hey @Tony Liardon,

What you are describing sounds like a setup with one zap in total. It could work like this:

Zap 1

  • Trigger: Stripe - New Charge 
  • Search: Google Sheets - Lookup Spreadsheet Row
  • Action: Microsoft Outlook - Send Email

Feel free to describe your challenge in more detail then I could go deeper into the setup :)


My struggle is getting Zapier to look up a piece of data in the Google sheet and insert that data into an email.

Can you help? Please.


Is the issue with looking up the data in the GSheet or inserting the data into the email?