I have a google sheets calendar list of events. I have it sorted by dates. I would I be able to import it in to Google Calendar as events? I work for a music department at a school district in NM. We have programs from elementary up to High school. This calendar has school names, type of programs, date, time and location of program. I cant seem to figure out to import from sheets to calendar.
Any Help would be appreciated.
Best answer by Troy TessaloneBest answer by Troy Tessalone
Hi
Good question.
You’ll need to use a column in the GSheet to trigger the Zap.
If you’re using the New or Updated Spreadsheet Row trigger and choose Any column to monitor, any change to a row will trigger your Zap.
If you select a specific column, then the Zap will only trigger when there are changes on that column.
Zaps using New or Updated Spreadsheet Row will also trigger for any new rows in the spreadsheet, even if the specified column is blank.
To avoid triggering in those cases, add a Filter step to your Zap.
+14Hi
Good question.
You’ll need to use a column in the GSheet to trigger the Zap.
If you’re using the New or Updated Spreadsheet Row trigger and choose Any column to monitor, any change to a row will trigger your Zap.
If you select a specific column, then the Zap will only trigger when there are changes on that column.
Zaps using New or Updated Spreadsheet Row will also trigger for any new rows in the spreadsheet, even if the specified column is blank.
To avoid triggering in those cases, add a Filter step to your Zap.
+8Hi
Checking in to see if you were able to take Troy’s tips above to get your Google Sheet list over to your Google Calendar.
If you run into any trouble or need help with that Filter, just let us know!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
