# Http between Google My Business and Google Sheets

**URL:** <https://connective.celigo.com/t/http-between-google-my-business-and-google-sheets/512>\
**Category:** Integrator.io\
**Tags:** pagination, http, google-sheets, export, handlebars\
**Created:** [March 15, 2023, 1:47pm UTC](https://connective.celigo.com/t/http-between-google-my-business-and-google-sheets/512 "2023-03-15T13:47:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![shadnerjoseph](https://avatars.discourse-cdn.com/v4/letter/s/c0e974/32.png) [@shadnerjoseph](https://connective.celigo.com/u/shadnerjoseph)\
**Post date:** [March 15, 2023, 1:47pm UTC](https://connective.celigo.com/t/http-between-google-my-business-and-google-sheets/512/1 "2023-03-15T13:47:21Z")

</div>

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](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/0/07f23fec4d9b97a21ef756a6835b308d3c3db131.png)

 ![5301043caa20740200000001-fccae79f880b47a1a38b755b6aa04d0c.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/5/5ea9bb8148b19bcea813c57d4de9e2fcb7405fe5.png)

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

---

<div class="post-metadata">

**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\
**Post date:** [March 20, 2023, 7:35pm UTC](https://connective.celigo.com/t/http-between-google-my-business-and-google-sheets/512/2 "2023-03-20T19:35:51Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![scotthenderson](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/scotthenderson/32/6780_2.png) [@scotthenderson](https://connective.celigo.com/u/scotthenderson)\
**Post date:** [October 19, 2023, 10:13pm UTC](https://connective.celigo.com/t/http-between-google-my-business-and-google-sheets/512/3 "2023-10-19T22:13:29Z")

</div>

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](https://docs.celigo.com/hc/en-us/articles/10031282236059-Working-with-Google-Sheets)). Hope this helps.