Google Spreadsheet to Google Calendar using Zapier

in #spreadsheet7 years ago (edited)

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