Google Ads "Run a custom report" module how to retrieve more than 500 rows

Hi Make Community, :wave:

I’m currently working on a scenario where I need to pull data from the Google Ads API using the “Run a custom report” module to retrieve product performance data from the shopping_performance_view. Here’s my GAQL query:

SELECT 
  segments.product_item_id, 
  segments.product_title, 
  metrics.clicks, 
  metrics.cost_micros, 
  metrics.conversions, 
  metrics.conversions_value, 
  metrics.value_per_conversion, 
  segments.product_type_l1 
FROM shopping_performance_view 
WHERE 
  segments.date DURING LAST_30_DAYS 
ORDER BY 
  metrics.conversions DESC 
LIMIT 10000

The query works fine, but I’m only able to retrieve the first 500 rows in Make. I understand that the Google Ads API uses pagination to handle larger datasets, but I’m not sure how to implement it in Make.

Here’s a brief outline of my scenario:

  1. Google Ads – Run a custom report (with the above GAQL query).
  2. Array aggregator – To aggregate the results.
  3. Google Sheets – Update bulk rows – To update my report in a Google Sheet.

I need to retrieve all the products beyond the 500-row limit. How can I handle pagination properly in Make to get all the results from my query?

Thanks in advance for your help! :pray:
Any detailed steps or best practices would be greatly appreciated.