I have 2 HTTP modules that I am trying to use to put data into Google Sheets then run calculations on.
The first one should be easy as it is only one number that I am trying to extract, a price.
I want it to be put into the same cell on Google Sheets each time it is run.
I have tried:
Having Parse Response Yes: This is what is pictured. The data comes out looking right but I am not able to bring it into Google Sheets.
I made a Google Sheet called ‘Nacho The Cat Data’ Sheet 1 is named ‘Price’ and has one column heading ‘USD’ Sheet 2 is called ‘Balances’ It has 2 column headings ‘Account’ and ‘Balances’. The Google Sheet is mapped to ‘My Drive’ Spreadsheet ID ‘/ Nacho The Cat Data’ Sheet Name ‘Price’ Values ‘USD (A)’. However when both HTTP modules and the Google Sheet I only get this:
[
{
“spreadsheetId”: “1ntXsJ-Dqo_9xOwgP9aI2Ab0-1mNzN97IZlKPhJBlNm4”,
“tableRange”: “Price!A1”,
“updates”: {
“spreadsheetId”: “1ntXsJ-Dqo_9xOwgP9aI2Ab0-1mNzN97IZlKPhJBlNm4”,
“updatedRange”: “Price!A2”
},
“sheetName”: “Price”,
“rowNumber”: 2
}
]
Having Parse Response No: My unparsed HTTP module gives me this:
],
“cookieHeaders”: [
“__cf_bm=JgrfNwWyM43PYXp7PnsebjLADUPoZrA4wFppI4qWxLY-1730031735-1.0.1.1-7nmyPMDb9x364TNq2PXVTjWhBlzkk_hg57NXp8twKCqsrjS4CKXmJkatW_V_n3_9N5W6StY5EjkfneHGSmIoow; path=/; expires=Sun, 27-Oct-24 12:52:15 GMT; domain=.api.coingecko.com; HttpOnly; Secure; SameSite=None”
],
“data”: “{"nacho-the-kat":{"usd":0.00021931}}”,
“fileSize”: 36
}
Tried JSON Parser: I have selected the outputs from the HTTP as input to the Json Parser::
{{4.data.result.holder.amount}}
But when I run them I get this error.
BundleValidationError
Validation failed for 1 parameter(s).
Missing value of required parameter ‘json’.
Tried Iterator: When I set it up and run it it asks me to make an input and doesn’t produce correct results.
Treid Aggregator: When run also asks me to make an input.
Could someone give me some advice on how to get this price into Google Sheets?
