Workflow Question: Can Pabbly Connect help on automating an RSVP tracker from a Google Calendar Invite?

[Gerace1011]

Hi there distinguished experts,

As the title states, Can Pabbly Connect help on automating an RSVP tracker from a Google Calendar Invite?

The ideal workflow I am thinking is this:

Google Sheet w/ Cold leads ----> Google Calendar Invite -----> Google sheet (RSVP tracker) will only record the name and email of those who said YES

 

[Preeti Paryani]

Hi @Gerace1011,

Yes, your use case is possible using Pabbly Connect. You’ll need to create two separate workflows to handle it effectively.

Workflow 1: Sending Google Calendar Invites to Cold Leads

This workflow sends invites to contacts listed in a Google Sheet.

1. Set Google Sheets as the trigger, which runs when new rows (cold leads) are added.
2. Alternatively, use the Pabbly Scheduler to fetch all rows at once instead of one by one.
3. Use the Line Itemizer to separate all emails into a comma-separated format.
4. Create a Google Calendar event and in the "Guests" field, map the emails.
5. This will send a Google Calendar invite to all listed emails. Invitees can respond with Yes, No, or Maybe.

Workflow 2: Tracking RSVP Responses

This workflow tracks the responses and logs only the "Yes" responses into a separate Google Sheet.

1. Use the Email Parser by Pabbly as the trigger.
2. When someone responds “Yes” to the invite, your calendar email receives a message with a subject like “Accepted: Event Title.”
3. Email Parser can capture these incoming emails.
4. Use a filter to only process emails where the subject contains "Accepted".
5. Extract the name and email from the email content.
6. Add the extracted data to your RSVP tracker Google Sheet.

This setup allows you to manage and track positive RSVPs automatically. Let us know if you need help setting this up.

 

[Gerace1011]

Thank you will try this one

 

[Gerace1011]

@Preeti Paryani do I still need to create a filter in my email origin (gmail) to forward the emails to the email parser address?

for the 2nd workflow to work? if yes, how can I verify it? I have no access to the email parser address.

 

[Preeti Paryani]

Hello @Gerace1011,

Apologies, but I'm not entirely clear on your query.

However, to help you set up the second workflow, you can refer to the attached tutorial to configure the Email Parser as the trigger. Once the trigger is set, you’ll need to add a Filter step after the trigger to check if the email subject contains the word "accepted".

Feel free to share more details or a screen recording if you need further assistance.