Best answer

Using zap with sheets and outlook

  • 23 December 2020
  • 4 replies
  • 38 views

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.

icon

Best answer by Ennes 23 December 2020, 09:06

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Userlevel 7
Badge +14

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

Userlevel 5
Badge +5

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.

Userlevel 7
Badge +14

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