Need help: Script to Synchronize existing sheet to existing Google calendar

Ask Anything
1

Hi,
In my Foundation Template I’ve added a ‘Bill Reminders’ sheet that lists bills paid monthly and annually; loosely based on a template that was briefly available a couple years’ ago. Among other columns, the sheet has ‘Bill Name’ and ‘Reminder Date’ columns. I’d like to be able to sync that sheet/info to my ‘Budget’ calendar in Google, creating calendar events.

With no scripting experience, I turned to ‘the Bard’ to generate a script for me; and, after a couple of iterations I think I have a short script that’s close … it finds my data and runs but I get calendar ‘method signature’ errors. I’d really like some help.

If anyone’s interested, I’ll be happy to share the sheet, calendar, and draft script. And if there’s a better/cleaner way of doing it, am all eyes/ears.

Thanks for considering,

Ben

2

Have you looked into having Zapier help with this?

I’m not sure on the scripting side, but there are some cool workflows and their free plan is pretty good.

3

Thanks for the lead, Heather. Wasn’t familiar with that. And, yes, I was able to link the calendar entries on their free plan (so far).

1 Like