Google Sheet Custom API Request trigger Google App Script Function

[nomisite]

Hi,

I am following this guide here https://forum.pabbly.com/threads/custom-api-request.19458/

What I intend to achieve is triggering my Google App Script's function to run first, before I attempt to search for the information i need in the Google Sheet. But I keep getting 403 The Caller Does Not Have Permission error

I did follow this to set up my google console project. https://forum.pabbly.com/threads/google-sheets-developers.21239/

I had also made sure that my google app script is set up correctly into the same google console project as well (https://developers.google.com/apps-script/api/how-tos/execute), here is the screenshot of my google app script project details

It is the same project number...

I do not know a better way of getting the app script's function to run. Maybe I am using the wrong app. Can anyone point me into the direction? I tried using Pabbly's API and I am stuck at the authorization there... Google needs to visit to the consent screen to get bearer token, or maybe i am missing the point?

Thanks

 

[Preeti Paryani]

Hello @nomisite

Please provide us with the workflow URL and the CURL request used. This will help us investigate and assist you better.

 

[nomisite]

Hi,

Workflow URL: https://connect.pabbly.com/workflow/mapping/IjU3NjYwNTZjMDYzNjA0MzA1MjZmNTUzNTUxM2Ei_pc
CURL request used: https://script.googleapis.com/v1/sc...jwM-yaHKkxJvcUeKtUS37yH4Cw0udjZb_OV_T3aTB:run

 

[Preeti Paryani]

Hello @nomisite

Upon reviewing the workflow, we noticed that you used Google Sheets instead of the Google Sheets Developer application. Please try setting up the workflow using the Google Sheets Developer Application to see if the issue persists.

Could you kindly provide us with the proper CURL request along with the API documentation so that we can investigate the issue?

 

[nomisite]

Hi,

the reason I am using Google Sheets because Google Sheets (Developers) dont have custom api request (beta). or else, can you guide me how to use google sheets (developers) and still send a curl to google with the same google account that i given access to google sheets (developers)?

like, do i use google sheets (developers) and then next step i use API (Pabbly) and it will automatically be using the authenticatino from google sheets (developers)?

CURL request: https://script.googleapis.com/v1/sc...jwM-yaHKkxJvcUeKtUS37yH4Cw0udjZb_OV_T3aTB:run

parameters: {"function":"getBotpressConversations"}

as for the API documentation, it is this one, https://developers.google.com/apps-script/api/how-tos/execute

In short, what i intend to achieve is, when i received a message on messenger, i want to trigger a function in google app script to run. this google app script will retrieve a result from botpress API, and store the result on google sheet. then, i will access to the google sheet to retrieve the result and send the output back to botpress API

i had already made the other steps work in another pabbly account. what i am stuck at now, is i couldnt trigger the function in the google app script to run when i received a message on messenger

thanks

 

[Preeti Paryani]

Hello @nomisite

We have enabled the Custom API Request(BETA) action in the Google Sheets(Developer) application, refer to the below image.

Kindly follow the following thread again and try setting up the workflow - https://forum.pabbly.com/threads/google-sheets-developers.21239/

If you face any further difficulties, please let us know.

 

[nomisite]

Hi

This works! thank you so much!