Having Problem with bulk uploading csv to my google sheet

[Shakti_Prithvi]

I created a scenario that monitors a specific folder in Dropbox for new CSV files. When a new file is detected, the scenario is triggered, and the file is downloaded. After downloading, the file is renamed. Next, a Google Sheet is created using a template. The data from the CSV file is then parsed and structured in the correct format before being uploaded to the Google Sheets API. However, I encounter issues whenever I attempt to send the data.

I have attached all the files: Which include the CSV I am trying to upload. My scenario blueprint. and also my Google sheet template.
blueprint (2).json (22.6 KB)
kwdevops-consulting-1-10-allworld-cleaned-2025-02-08.csv (6.9 MB)
here is the Google sheet template:

{{Template for csv to googlesheet}}

here is the screenshot of the scenario:

Here are the settings inside my Google sheet API and text aggregator modules:

I need your help solving this identifying what is the problem and how I can solve it.
Please answer quickly

[momomomonmon]

Thank you for your detailed explanation.
I feel that perhaps there is an error in the Body specified in the Make an API Call Module in Spreadsheet.

However, I feel that what you are trying to implement in the Make an API Call Module is no different from the Add a Row Module in Spreadsheet.
Is there a reason you are not using Spreadsheet’s Add a Row Module?
If you are using the Add a Row Module, I feel that you can implement it by simply specifying the Parse CSV Response in the Add a Row Module settings.

[Shakti_Prithvi]

I want to do it in bulk as it will take less credits
thats why i am using the api module as there are 2500 rows so it will exceed the limit of any plan or consume a huge chunk.

[EyalGershon]

There is a “Bulk Add Rows” module for Google sheets.
You need to add an array aggregator before it, set the rows as the target and map the data from your "Parse CSV " module

[Shakti_Prithvi]

Thank you it has been done and working properly