How do I schedule a daily joke event on Google Calendar from Google Sheets rows?

Hi,

First time trying something. I was looking for a joke a day calendar, but couldn’t find a funny one.

I want to copy and paste jokes into a spreadsheet and have it output the 365 jokes to each day on the calendar.

I sort of understand the process, but need help maybe with formatting and maybe the right triggers.

I tried creating column A and filled it with Days of the year.

I started filling Jokes in column B.

I’ve connected my Jokes Google Sheet and My Google Jokes Calendar.

Do I need more data than that?

I’m pretty novice with spreadsheets and just learned how to fill the row with dates.

Thank you for your time and help.

Brandon

Page 1 / 1

Hi @ABuzzBuzz

You can do it by setting up a zap using following steps:

Trigger: Schedule by Zapier - Daily
Action: Lookup google sheet spreadsheet row: Search the date column using the date from first step (which will be the current date)
Action: Google calendar - add calendar event with the date and joke text from spreadsheet data

Hi @ABuzzBuzz

Good question.

A different approach might be to use Airtable instead of GSheets.

Airtable has a built in GCal integration that can be used in Airtable Automations.

If you wanted to use Zaps to connect Airtable to GCal, then you can create a View.

Views have Filters. (e.g. Date = TODAY)

Views can be used to trigger Zaps, which would save you Zap Tasks.

Sign up