email report - daily appointments

[aristosv]

I would like to send an email every day at 00:00, containing the Google Calendar appointments for that day. Just the summary of each appointment will do fine.

I know how to read all the appointments in a Google Calendar and how send the email.

But I don't know how to limit the result for that specific day only.

Any guidance is appreciated.

 

[aristosv]

no way to do this?

 

[Pabblymember11]

Hey @aristosv

I know how to read all the appointments in a Google Calendar and how send the email.

But I don't know how to limit the result for that specific day only.

Could you please elaborate on the second part of your concern and let us know if you have any existing workflow where you have tried the same.

 

[aristosv]

Basically I need a daily email, showing me the appointments for the day. A simple list with the "Summary" field for each appointment. I haven't created any workflow yet because I don't know which logic to follow to achieve my goal.

I don't know if I should pull all the events in a calendar and then filter the ones for the current date. Or somehow pull the events for the current date only.

Also, once I have the a list of events, how do I pick up only the summaries for all the events and email them? Do I put them in a Google sheet? Is there a way to email them directly?

I just need suggestions on the logic I must follow.

 

[Pabblymember11]

Hey @aristosv

Please check out the following shared workflow for your concerning use case. Kindly try this at your end and let us know if that works for you.

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

 

[aristosv]

I connected my calendar and pulled all events

but the iterator is not pulling any information

 

[Pabblymember11]

Hey @aristosv

You have to capture the API response in Advance response by toggling the "Simple Response" button. Please check the shared workflow carefully.

 

[aristosv]

It seems to be working, but in the email I receive, there's only one appointment, and it's the one detected when clicking on "Save and Send Test Request" on the iterator. The workflow name is "Report Testing". Can you have a look please?

 

[aristosv]

When I let the schedule run the workflow, the task history shows that it's processing a lot more data. But it never reaches the part where it sends the email

 

[Pabblymember11]

Hey @aristosv

Perhaps you do not have the presents day's date event in your Google Calendar and because of that mail didn't send to anyone.

Kindly check the date in your Google Calendar and try again.

 

[aristosv]

I didn't understand. Where is the information missing from? The calendar event? Or in my workflow?
I checked all the steps in the workflow and they all produce results.

 

[Pabblymember11]

Hey @aristosv

checked all the steps in the workflow and they all produce results.

Your workflow didn't send the notification because your respective Google Calendar didn't have any event on 13/04/2022.

Kindly make an event of the current days and then try again.

 

[aristosv]

ok now I got an email, but, I received an email for each appointment of that day. So I have 6 appointments for today, I received 6 emails containing the information for each appointment. I need to receive 1 email containing the information for all the appointments of the day.

 

[aristosv]

this method will not work because: as per the Google Calendar's API Google Calendar's Get All Event always retrieves the events from Old to new and it can only provide 250 events at a time.

 

[Pabblymember11]

Hey @aristosv

We have replied to your use case on your another thread, kindly check that out.

Get All Events doesn't really pull all the events

I am using this action to pull all calendar events I get the .json file created, and I can see that the most recent event in that google calendar is on 16/03/2022 I search the .json file for "2022-04-15" but nothing is found. But when I look at the calendar itself, I can see that there...

forum.pabbly.com