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
-
Official comment
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.
-
Shadner Joseph 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?
1
Please sign in to leave a comment.
Comments
2 comments