Google Sheet data to 3rd Party API

[troycoker08]

Hi, I have a Google Sheet FTP to Google Drive daily. It contains multiple line items and multiple rows. The sheets has a Header row. The 3rd party application allows for POST to API which I have been doing as the new data hits the Sheet, I webhook the new row payload to Pabbly and then POST to the 3rd party app.

My problem is POSTing to the API daily from a Sheet that already has all the data. No single new row can trigger the POST. Is it possible to use Pabbly update all of the rows via the 3rd Party API?

Thanks

 

[Supreme]

Hey @troycoker08

My problem is POSTing to the API daily from a Sheet that already has all the data.

Could you please explain to us what you exactly mean by that?

Although as per your concern, you can make it in automation by using the Google sheet trigger and then map the data fetched by trigger into the next step of your action that is 3rd party API, to do that you can you API by Pabbly.

Also, you can create another workflow in which you can basically insert the data into a sheet which will then trigger the google sheet trigger which is in the previous workflow in this way you will not have to manually add the data into Google sheets.

please give us more brief detail if got your problem wrong.

Thanks.