search

davepar / gcalendarsync

Apps Script for syncing a Google Spreadsheet with Google Calendar
MIT License
161 stars 46 forks source link

Sync multiple tabs in 1 script #65

Closed joelando closed 4 years ago

joelando commented 4 years ago

Hi there, The current Script working great. I've set it up with a trigger to update daily, but have 1 other thing I'd like to edit (with my limited exprience).

I see everywhere SpreadsheetApp.getActiveSpreadsheet (). What I'd like to do is set up this script to work with multiple 'Sheets' (tabs). Ideally this would run as 1 master Script to save work/ editing in the future. For this the 'URL' to this spreadsheet could be fixed, and each going to its own CalendarID. And need to set up this with various tab names 'John', 'James', etc.

I'd rather have this all running from 1 Google Sheets instead of creating separate Google Sheet document, and having to copy n paste.

Any ideas for this setup? I'm using the Spreadsheet > Calendar function only.

Any ideas welcome! and any questions let me know.

Thanks, Joel

joelando commented 4 years ago

@Davepar Dave, any ideas? This is similar to https://github.com/Davepar/gcalendarsync/issues/62

but I don't yet follow his instructions without seeing code/ document.

Any ideas to help?

Thanks