Hi everyone,
I’m currently working on a scenario in Make where I:
- Retrieve a list of ASINs from Google Sheets .
- Use the Amazon Seller Central - Get a Catalog Item module to fetch product attributes for each ASIN (since the API can only fetch one ASIN at a time).
- Use the Set Variable module to format and extract the relevant data (ASIN and Recommended Browse Nodes).
- Then, use the Array Aggregator to combine the ASIN and Browse Node data for all ASINs into one list.
- Finally, I use Google Sheets - Bulk Update Rows to upload all the data in one go.
The problems:
- Each ASIN is processed one by one , and the Google Sheets - Bulk Update Rows module is running after each individual ASIN, rather than waiting for all ASINs to be collected and then bulk uploading all the data at once. This causes the data to be uploaded ASIN by ASIN, rather than in a single batch.
What I need:
- I need the Array Aggregator to collect all the ASINs and their corresponding data (ASIN and Recommended Browse Nodes) before Google Sheets - Bulk Update Rows runs, so I can upload all the data in a single batch.
What I’ve tried:
- I’ve placed Set Variable before Array Aggregator to format the data and then collect it, but the flow is still processing each ASIN one by one.
- Google Sheets is overwriting data in the same range because the upload occurs for each ASIN individually, instead of after all ASINs are aggregated.
I have attached an image of the flow and as you can see from the image every module from step 2 and to the end runs 3 operations at a time.
Does anyone have a solution or advice on how to Collect all ASIN data and collecting it as a batch before continuing the flow to Google Sheets?