pipedream icon indicating copy to clipboard operation
pipedream copied to clipboard

[Appsheet Integration]

Open reatcas opened this issue 3 years ago • 6 comments

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

reatcas avatar Jul 24 '22 03:07 reatcas

Thanks for the request! We've added this to our integrations backlog, and we'll update this ticket with progress.

dylburger avatar Jul 24 '22 06:07 dylburger

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).

sergioeliot2039 avatar Jul 24 '22 07:07 sergioeliot2039

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.

MultiTech-Visions avatar Jul 25 '22 14:07 MultiTech-Visions

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.

sergioeliot2039 avatar Jul 27 '22 17:07 sergioeliot2039

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: @.***>

MultiTech-Visions avatar Jul 27 '22 18:07 MultiTech-Visions

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,

sergioeliot2039 avatar Jul 28 '22 04:07 sergioeliot2039

Without more information, I'm going to close this issue. Feel free to reopen and add more details, if you'd like.

dylburger avatar Aug 04 '22 23:08 dylburger

Sorry, that message by Dylan was triggered by an automation. I have reopened the issue. Appsheet integration is pending approval.

sergioeliot2039 avatar Aug 04 '22 23:08 sergioeliot2039

Without more information, I'm going to close this issue. Feel free to reopen and add more details, if you'd like.

dylburger avatar Aug 12 '22 23:08 dylburger

Hi @reatcas , @MultiTech-Visions Google App sheet has been integrated https://pipedream.com/apps/google-appsheet let us know if you see any issues

sergioeliot2039 avatar Aug 15 '22 23:08 sergioeliot2039

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: @.***>

reatcas avatar Oct 11 '22 08:10 reatcas

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.

sergioeliot2039 avatar Oct 11 '22 09:10 sergioeliot2039