Error Message GCalendar Sync

davepar / gcalendarsync

Apps Script for syncing a Google Spreadsheet with Google Calendar

MIT License

161 stars 46 forks source link

Error Message GCalendar Sync #85

Open 124stabbo opened 3 years ago

124stabbo commented 3 years ago

I tried the app on a separate worksheet importing it to a calendar to check it would do what I wanted, I then moved to my worksheet I wanted (deleted the test sheet and calender) and I now receive the error

TypeError: data[Util.CALENDAR_ID_ROW][0].replace is not a function

I have checked the ID and the column heading and they appear to be correct.

Can you shed any light for me, please?

Thanks

Jason

Enounce commented 3 years ago

I receive the same error today with a sheet that was working yesterday. I have several other tabs in the workbook which I've made changes to, but the calendar sync template has not been edited.

Edit: I found out an image link in another tab caused the issue for me.

=image("https://images.unsplash.com/photo-1444703686981-a3abbc4d4fe3?ixid=MnwxMjA3fDB8MHxzZWFyY2h8Mnx8cGljdHVyZXxlbnwwfHwwfHw%3D&ixlib=rb-1.2.1&w=1000&q=80",3)