Google Sheets - Add multiple row with a JSON

Help
1

Hi Guys:
I am having a really hard time trying to add multiple rows to a gheet from a JSON code from a previous step. I am not a programmer so the question could be obvious but not for me.

This is the code that I get from the API

image
image858×516 24.9 KB

And then I tried to use the JSON.parse function to sent it to ghseet but always appears this error “Unexpected token c in JSON at position 1”. Can you help me to see what is happening please?

All your help is really apréciate

Thank you

2

Hello @david,

First off, welcome to Pipedream! Happy to have you!

Here’re some guidance for you I would suggest:

  1. Read more about Javascript, especially Node.js part. Also you can watch through Pipedream speedrun series to have more references
  2. Submit a ticket for Pipedream, stating the action on the app that you need
  3. If you have subscribed to Pipedream team plan, you will be added to a dedicated slack support channel
  4. If you’d like to hire a Pipedream expert for your usecase, feel free to use this link: Connect with a Pipedream Partner