Question

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

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

Userlevel 7

+9

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

Userlevel 7

+14

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