(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.
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
got it working, moving onโฆ
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.โ} |
Thanks for the feedback, Matt. We will look into this & get back.
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |