How to sync spreadsheet and google calendar

[amufaamo]

I use spreadsheet and google calendar for task management. I want to sync the sheet and google calendar by appsheet. But I got an error.

First, I made action “add a new row to another table using values from this row”

Sheet → Google calendar

[Thing] → [Title]

[Start] → [Start]

[End] → [End]

Then, I made the automation. When some data changes, run the action above.

But it failed. I got error below.

It looks Google calendar does not have key. But, I cannot set Row ID by action. It does not exist

So how can I sync sheet and google calendar?

[Marc_Dillon]

Seems like you just misread the error message.

“field ‘Creator’ is required to have a value”

[amufaamo]

OK, sorry.

Does it mean I need to add some value?

[amufaamo]

I understood. I added my E-mail address in initial value of google calendar. It worked!! Thank you