Question

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

  • 19 February 2023
  • 2 replies
  • 78 views

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.

2 replies

Userlevel 7
Badge +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
Badge +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.