How to connect Google Sheets to the Web API component

Check this out, maybe you can draw inspiration. I used this to post on a payment API but the documentation was quite good which made it easier. I edited some parts to remove details but this gives you the post idea. Just know you will need three parts. The URL web API, the Headers which has the authorisation keys (where applicable) and the Content-Type (this may not be required sometime). Then the body (this is what you are writing/posting from your app to the API.

1 Like