Hi,
I need to create GDocs and GSheets from within the AppSheet app and define the path and name of the file.
Is there a GDrive API integration possible with AppSheet trhat would provide this functionality ?
Regards,
Frank
Yes, I believe you can though I have not yet done so. AppSheet supports REST APIโs. since Googleโs Sheets API is REST based then you should be able to talk easily from AppSheet to the Sheets API.
In AppSheet is is referred to as a Webhook. You will need to understand the criteria for both sides.
Below is the document for Webhooks. Youโll then need to review the Sheets API for proper content to send.
He meant if there is any way we can write rows of our table into a google doc with specific template just like creating PDF. Also according to a client that will be a unique key column we need different Gdoc file in different folder. As of now we can do that with PDF but how to do it with google doc ?
Nope.
I donโt understand. The key column must occur in the same file as the rest of the table; it cannot exist in another file in a different folder.
thx for replies )
so what I need to achieve right now with the GDrive API integration to AppSheet is to :
So thatโs the tasks right now I need to see if it can be done with AppSheet.
That is what I understood you were looking for and I believe you can do so. There is not a built in integration in AppSheet yet to Google API (Iโm sure will be coming) but AppSheet does provide a generic ability to call REST APIโs. Its simply a matter of understanding what the Google API expects to be given and how you provide that information from AppSheet.
Unfortunately, though I have created integrations with REST APIโs in the past, I have not yet done so in AppSheet. I canโt help with the formatting. Others in the community can help with specific questions as you start building out the capability. Hopefully, the article above and Googleโs API documentation will help you get started.
User | Count |
---|---|
44 | |
34 | |
24 | |
23 | |
15 |