This post is from a low-reputation account and contains an unverified outbound link. Be cautious before clicking external links.

Google Spreadsheet to Google Calendar using Zapier

Words
81
Reading
1 min
Listen
Play
9y

Google Calendar is good method for sharing schedule.

Surely, user can input directly it. But manager needs another form.

So, manager can receive members working list with date specific form.

The specific form made by Google Form or Google Spreadsheet, like below:

ss.jpg

After members report their work data, manager handle it freely.

I recommend Zapier to you, like this.

zapier.png

If your setting has no problem, Google Calendar says "members schedule", easily.

cal.png

Zapier will support you to write required fileds, kindly.

Go!

cal.gif

https://zapier.com/apps/google-calendar/integrations/google-sheets/542/use-a-google-form-to-add-new-events-to-a-google-calendar

Google Spreadsheet to Google Calendar using Zapier | Ecency