pipedream
pipedream copied to clipboard
[Appsheet Integration]
Name of app / service Appsheet
Link to developer documentation Appsheet Documentation
Is lack of support preventing you from building workflows, or do you have a workaround? No, it just could be more versatile to have a direct integration
Are there specific actions, or triggers, you'd like to see for this app? Please let us know here or use the Action and Trigger issue templates to open requests for each! Just general triggers adds, updates, deletion
Thanks for the request! We've added this to our integrations backlog, and we'll update this ticket with progress.
Hi @reatcas, thanks for the request!
So I collaborate here on Pipedream to add new app requests on our integrations. I run into an issue trying to work through AppSheet. Do you have access to the API? I created a free account but although I have access to the API management on the dashboard, I am unable to test it because the API access is available on Enterprise Standard and Enterprise Plus plans .
Are you able to create a new test app on AppSheet and share with me App Id and Application Access key for testing the integration?
Otherwise you can also try setting up the app here: https://pipedream.com/submit-an-app (this is an early alpha UI, so please let me know if you run into any issues).
Hey everyone; just thought I would chime in here, as I've got some experience with AppSheet.
As you already noticed, there are a few licensing requirements that might need to be taken into consideration. For instance, you can't utilize the AppSheet API externally unless you've got an enterprise license. (Which... isn't the cheapest of options.)
- This typically prevents most developers from continuing down this path
FYI: you can SEND info using the API, but you can't receive it back to the AppSheet API without the enterprise license.
Just thought I would through that out there while you're testing things.
- Let me know if you have any other questions, happy to help.
Hi @MultiTech-Visions , thank you for jumping in.
One question, before I go try your suggestion
FYI: you can SEND info using the API, but you can't receive it back to the AppSheet API without the enterprise license.
does this mean i.e add records to a table?
so I'd use a request like this:
POST https://api.appsheet.com/api/v2/apps/{appId}/tables/{tableName}/Action
(taken from the Add records to a table article)
did I get this right? Just wanted ask and make sure I understood correctly the idea.
Yeah you've got the right idea;
The restriction on using the API, in regards to requiring an enterprise license, is only if you plan to invoke it externally.
Wishing you the best Matt https://en.wikipedia.org/wiki/Autism_rights_movement
YouTube http://www.YouTube.com/MultiTechVisions?sub_confirmation=1 | LinkedIn https://www.linkedin.com/in/multitech-visions/ | Patreon https://www.patreon.com/multitech | www.MultiTechVisions.com
On Wed, Jul 27, 2022 at 12:24 PM Sergio E. Rodríguez Wong < @.***> wrote:
Hi @MultiTech-Visions https://github.com/MultiTech-Visions , thank you for jumping in.
One question, before I go try your suggestion
FYI: you can SEND info using the API, but you can't receive it back to the AppSheet API without the enterprise license.
does this mean i.e add records to a table? so I'd use a request like this: POST https://api.appsheet.com/api/v2/apps/{appId}/tables/{tableName}/Action (taken from the Add records to a table https://support.google.com/appsheet/answer/10104797 article)
did I get this right? Just wanted ask and make sure I understood correctly the idea.
— Reply to this email directly, view it on GitHub https://github.com/PipedreamHQ/pipedream/issues/3512#issuecomment-1197074960, or unsubscribe https://github.com/notifications/unsubscribe-auth/A2HAXGUMKWJR5RASYEMHFXDVWFWGDANCNFSM54O7S25Q . You are receiving this because you were mentioned.Message ID: @.***>
Thank you @MultiTech-Visions , I was able to try the App Sheet API within AppSheet automations (using a bot and a process containing a webhook task).
AppSheet integration is now under review by the Pipedream team.
Best,
Without more information, I'm going to close this issue. Feel free to reopen and add more details, if you'd like.
Sorry, that message by Dylan was triggered by an automation. I have reopened the issue. Appsheet integration is pending approval.
Without more information, I'm going to close this issue. Feel free to reopen and add more details, if you'd like.
Hi @reatcas , @MultiTech-Visions Google App sheet has been integrated https://pipedream.com/apps/google-appsheet let us know if you see any issues
Hi Sergio!
Thank you very much for the support. I will submit the app as soon as possible.
Get Outlook for Androidhttps://aka.ms/AAb9ysg
From: Sergio E. Rodríguez Wong @.> Sent: Sunday, July 24, 2022 1:12:44 AM To: PipedreamHQ/pipedream @.> Cc: Rene Antonio Casaña Amaya @.>; Mention @.> Subject: Re: [PipedreamHQ/pipedream] [Appsheet Integration] (Issue #3512)
Hi @reatcashttps://github.com/reatcas, thanks for the request!
So I collaborate here on Pipedream to add new app requests on our integrations. I run into an issue trying to work through AppSheet. Do you have access to the API? I created a free account but although I have access to the API management on the dashboard, I am unable to test it.
Are you able to create a new test app on AppSheet and share with me App Id and Application Access key for testing the integration?
Otherwise you can also try setting up the app here: https://pipedream.com/submit-an-app (this is an early alpha UI, so please let me know if you run into any issues).
— Reply to this email directly, view it on GitHubhttps://github.com/PipedreamHQ/pipedream/issues/3512#issuecomment-1193261883, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ADZWW32E5HQ75UJN5IDJ7ILVVTUGZANCNFSM54O7S25Q. You are receiving this because you were mentioned.Message ID: @.***>
René, thanks for getting back to us
AppSjeet was already integrated at https://pipedream.com/apps/google-appsheet
Can you use it on Pipedream just or testing? Having feedback from our end users is much appreciated.