We just updated the primer to version 1.1. This has a brand new use case that allows processes to be triggered from data in Google Sheets. Please check it out and let us know what you think!
It works when I run it from the app, It doesnโt work when I enter directly into Google sheets. Iโm not sure if itโs supposed to, but here is the error messageโฆ
from the Google Apps Script Execution history, Iโm getting this when I add to my leads or โcontactsโ table.
{"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.โ} |
Hi Matthew. The add-on needed to make this work has now been released. It can be accessed with this link: https://gsuite.google.com/marketplace/app/appsheet_events/592572205846
Please install that add on, add your API-Key, and try again
Does this look right? i see a lot of xโs
does the api key still need to be the key from the app + table name?
Hi Matthew,
The API Key is now just the key by itself. it should be in a form similar to: V2-7Dtmy-XXXXX-XXXXX-XXXXX-XXXXX. Your key seems to be in a url format; this should not be the case. It should be the key from Manage > Integrations > IN: from cloud services to your app. You should enter the complete key (unmasked), and it will be displayed in a masked form.
Temi
Ok, thanks Temi. I have the correct key now.
I tried to update the key but the add-on doesnโt seem to allow it.
I removed it, reinstalled, but do not see it anymore in the add-ons (just the normal appsheet add on). Is it a delayed install?
Hi Mathew,
You shouldnโt have to uninstall the add-on. Your should be able to delete the key and add another key. Also, if you uninstall and install again, the add-on should show up immediately after you refresh the google sheets window.
One thing to note is that even if you re-install, the bad key will still be there, so you will need to remove that key and add the correct key. Please let me know if you are still having issues after that.
Thanks,
Temi
Ok, thanks Temi - It is working.
My issues was - I have 3 google accounts. One is a gsuite and it was trying to do a domain install.
I went to incognito and it worked better.
After that, worked perfectly.
Awesome! Glad to hear it!
this add on doesn't seem to work in my app. I have the add on in my google sheet, which is connected to the app and still when i submit a form this does not trigger the bot i have created.
I don't see an option to check/update the API key in the add on
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |