Update Google Sheets from CSV

[maxxer]

What are you trying to achieve?

Hi.
I am posting a CSV file to a webhook, going through Parse CSV, and then I want to update a Google Sheet from it. I don’t really care about the sheet, as it should be changed with the dat coming from the CSV/Webhook.

I tried to set up the workflow, but when I post the data to the webhook, the scenario correcly processes the number of rows in the CSV, but nothing is updated on the Sheet.

What is odd to me is that in the execution history, all the tasks on the Google Sheets module contain the same range. The example below is from Operation 15, but it still seems to update A1.

Input
  Bundle 1 (Collection) 
    Range	A1:C300
    Sheet Name	Data
    Spreadsheet ID	xx
    Value input option	USER_ENTERED
Output
  Bundle 1 (Collection)
    Spreadsheet ID	xxx
    Updated range	A1
    Sheet Name	Data
Raw Updated Range	Data!A1

Steps taken so far

1. Created the incoming Webhook
2. Added a Parse CSV module to convert binary data with toString()
3. Added a Bukl Update Rows (Advanced) to update the sheet.

Thanks

Screenshots: scenario setup, module configuration, errors

[damato]

Hi @maxxer

The way Parse CSV module works is by returning a bundle for each row parsed. This way, every module after Parse CSV will execute once for each bundle (row parsed).

The way Bulk insert works is by receiving an array where each value is a row to insert (a bundle from Parse CSV).

Thus, you need an aggregator between Parse CSV and Google Sheets Bulk insert.

Aggregate the results from the csv. Then, just insert the resulting array.

@damato