I have a flow that uses SerpAPI, outputs JSON, then a Google sheets "Add multiple rows" piece that takes that JSON and adds to the sheet. But its saying the input is not JSON. Im looking at the code given by SerpAPI and its definitely JSON

can share with us screenshots of your flow or at least send us the flow link ?

are you sure the column names match the response data ?

the sheet is empty at the minute

it won't create them, both the sheet and the value you put must have the same column names

so if i download the JSON and use a converter to convert it to Excel, copy all the headers to google sheet it should work you think?

yes

perfect thank you