I’d like that anytime there’s an event in my Google Calendar called “EVENT X”, an email is sent from my Gmail account to “xxxx@gmail.com”, with the following text “Hi, here you have the table: [TABLE]”. I want to take the [TABLE] data from a Google Sheet where Zapier will always find updated data in cells P39:T43.
Can you please help me?
Best answer by simplifywork
Assuming you’re keeping the same sheet and range for these emails, this will work for you!
That should give you a direct link to the table, which can continue to be updated from the sheet itself!
Please let me know if I missed anything with this or if you have any questions.
+14Hi
Good question.
Make sure to review the available help articles for using GSheets in Zaps as GSheets have to be configured a certain way: https://zapier.com/apps/google-sheets/help
Can you outline a specific example for us to add more context?
Hey
thank you
+14Screenshots would be helpful to understand how your GSheet is configured.
Screenshots with how your Zap steps are configured will help add context.
this is the screenshot of the GSheet sheet. I’d love to copy the [P49:T54] table into an email and send the email to a specific address. The trigger of this email sent should be a recurrent GCalendar event, that occurs every month on the 27th and is called “Reminder A”. Which are the Zap steps I should follow?
+14Help article for how GSheets need to be configured to work with Zaps: https://help.zapier.com/hc/en-us/articles/8495978765965
Assuming you’re keeping the same sheet and range for these emails, this will work for you!
That should give you a direct link to the table, which can continue to be updated from the sheet itself!
Please let me know if I missed anything with this or if you have any questions.
Hey
Step 2 seems to be incorrect: I already have the events in calendar, I just want to trigger the Zap when the event is about to start. The event is a recurring event that occurs every month in a specific day and always has the same name event “Reminder A”. Can you please help me setting this trigger up?
+14We’d need to see detailed screenshots with how your Zap steps are configured in order to have enough context, thanks.
Hey
Step 2 seems to be incorrect: I already have the events in calendar, I just want to trigger the Zap when the event is about to start. The event is a recurring event that occurs every month in a specific day and always has the same name event “Reminder A”. Can you please help me setting this trigger up?
Great! Good news
If you swap in that trigger it should work. Let me know if it still isn’t working though!
+9Hey there,
Keep us posted! 🤗
Hey there, thank you all for the support.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
