Import Mailchimp Data to Google Sheets

Import Mailchimp Data to Google Sheets

Comments:9

    1. The Mailchimp API documentation says:
      Paginate your API requests to limit response results and make them easier to work with. We use offset and count in the URL query string to paginate because it provides greater control over how you view your data.

      Offset defaults to 0, so if you use offset=1, you will miss the first element in the dataset. Count defaults to 10. For example, this URL includes query string parameters for pagination: https://usX.api.mailchimp.com/3.0/campaigns?offset=0&count=10

      What this means is that by default, Mailchimp only provides 10 records at a time. To get more, change the parameters at the end of your URL, e.g.:
      https://us20.api.mailchimp.com/3.0/campaigns?count=50

      Then to get the next 50 results, you’d enter:
      https://us20.api.mailchimp.com/3.0/campaigns?offset=50&count=50

  1. This is great!

    Is there a more efficient way to retrieve data count with 60,000 + rows rather than running the api request 65 times?

Leave a Reply

Your email address will not be published.