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.
Best answer
Using zap with sheets and outlook
- Beginner
Best answer by Ennes
Hey
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 :)
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
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
+5- Tinkerer
- Answer
Hey
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 :)
- Beginner
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.
+14- Zapier Orchestrator & Solution Partner
Is the issue with looking up the data in the GSheet or inserting the data into the email?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.