Http between Google My Business and Google Sheets

Good Morning,

I am having an issue where I am only able to export a single review to google sheets. I am trying to receive multiple while using the next page token for the pagination method. I am only receiving one review which is the last review on the first page. When I turn off the pagination settings I am receiving the same response. In total there should be 856 reviews.

Thank you for any and all help.

Handlebar Template:

{

"values": [


{{#each data}}

["{{reviewId}}", "{{createTime}}", "{{displayName}}"]

{{#unless @last}},{{/unless}}{{/each}}

]

}

Ending relative URI for google Sheets:

/values/Sheet1!A:N:append?valueInputOption=RAW&insertDataOption=INSERT_ROWS

@shadnerjoseph I'm not completely following you, but it sounds like you are wanting to GET google business reviews and then insert those into a google sheet, is that correct? When you run the source/export step to get reviews, it's only returning 1 result? Can you provide screenshots of the flow and settings within the flow?

We published a brand new template in our marketplace that makes it super easy to work with Google Sheets. We published a new article too explaining all the details (here). Hope this helps.