Http between Google My Business and Google Sheets

Integrator.io
, , , ,
1

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.

5301043caa20740200000001-0fbb7444bcbd416bbb299362996075b3.png
5301043caa20740200000001-0fbb7444bcbd416bbb299362996075b3.png762×226 5.23 KB

5301043caa20740200000001-fccae79f880b47a1a38b755b6aa04d0c.png
5301043caa20740200000001-fccae79f880b47a1a38b755b6aa04d0c.png803×774 13.2 KB

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

2

@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?

3

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.