Google Sheets Eventing: How was your experience working through the 'Conference leads appointment generator' use case?

[dsharda]

(Ref: Google sheets external eventing)

How was your experience working through the ‘Conference leads appointment generator’ use case?

We would love to hear your feedback.

[Matthew_Brown]

I’m getting hung up here:

Follow the steps below to configure the permissions and authorization required for your Sheet
to communicate with AppSheet:
1. Return to the Sheet you opened in Step 1 of the previous section and refresh the page.
2. Configure permissions for your Sheet:
a. From the top navigation, select Add-ons > App

When I go to the sheet I do not see the add - on script…still looking, I wonder if it’s getting confused b/c I have multiple google accounts in my chrome browser

[Matthew_Brown]

got it working, moving on…

[Matthew_Brown]

from the Google Apps Script Execution history, I’m getting this:

{"Message":"No HTTP resource was found that matches the request URI 'https://www.appsheet.com/api/v2/app-events?type=ADD'.","MessageDetail":"No action was found on the controller 'PublicAPIV2' that matches the request."}

I generated a new api and used the table name at the end of it…

Jan 4, 2021, 1:01:09 PM	Info	whenEdit function called
Jan 4, 2021, 1:01:09 PM	Info	{“authMode”:“FULL”,“range”:{“columnEnd”:7,“columnStart”:1,“rowEnd”:3,“rowStart”:3},“source”:{},“triggerUid”:“5788092”,“user”:{“email":"corpitappsheet@gmail.com”,“nickname”:“corpitappsheet”}}
Jan 4, 2021, 1:01:10 PM	Info	{“data”:[{“First Name”:“Matt”,“Last Name":“Brown”,“Email”:"mbrown3@ebsco.com”,“Company”:“EBSCO”,“Date”:“2021-01-04T06:00:00.000Z”,“FollowupRequested”:“Y”,“FollowupAfterDays”:10}],“tables”:[{“api-key”:“V2-VKbyn-s3J91-6as5j-hCJoM-yMCBE-EkWkP-6qXu1-5vSR9”,“table-name”:“Contacts”,“schema-version”:“1.0”}]}
Jan 4, 2021, 1:01:10 PM	Info	https://www.appsheet.com/api/v2/app-events?type=ADD
Jan 4, 2021, 1:01:10 PM	Info	{“Message”:“No HTTP resource was found that matches the request URI ‘https://www.appsheet.com/api/v2/app-events?type=ADD’.”,“MessageDetail”:“No action was found on the controller ‘PublicAPIV2’ that matches the request.”}

[dsharda]

Thanks for the feedback, Matt. We will look into this & get back.