• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Google Sheet Custom API Request trigger Google App Script Function

Status
Not open for further replies.

nomisite

Member
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

1728956586520.png


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

1728957867236.png


1728957898104.png


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

Well-known member
Staff member
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.

image (35).png


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

nomisite

Member
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
 
Status
Not open for further replies.
Top