Hello, I’am struggle with a simple task :
I have an Excell .csv file with 16 columns and 3621 rows.
I need to translate the column “Review” from french to polish.
I made several Scanarios with the same structure :
Google Sheet/Excel > DEEPL > Google Sheet/Excel (Update)
But they all failed.
Can someone help me please?
Can you share the errors or what is wrong.
The file needs to be in sheets format and not .xlxs for the google sheets api to work.
1 Like
Hi Mr Make,
Thank you for your help 
The error is in the 3rd module :
“* The operation failed with an error. Validation failed for 1 parameter(s).”
You can see the Make Scenario in the screenshot attached.
The google sheet: reviews.Vy-zEtQm9P (2) - Google Sheets
If you need anything do not hesitate to ask me, Thank you again!
Your starting point is wrong. See that first circle with a clock on? — start by inserting sheets there
2 Likes
You are entering a collecting of data to upload to google sheets where it should be an array of data. You need to do the following.
- Aggregate the data needed from your collection
- Use the new array of data to push this to google sheets.
1 Like
This is much better! 
The scenario executes up to the last module.
It just encounter an error at the last module. I think i don’t fill the good fields in the Array aggreator module or the last one. See Screenshots attached.
Thank you again Mr.Make
You need to increase the range of rows you are inputting your data into. you are only doing one column. Give it more space.
i don’t know how to do i’m sorry 
You do know how to do it, do not give up lol.
You need to increase range in the bulk update google sheet module where you have it set from G2:G3622
Give it more columns to allow for the number of items you are adding and the number of columns you are using.
This means if you are sending over 4 keys in the aggregator to give it from D2:G3622
2 Likes
I would just do like
A2:Z10000 give it as much room as possible.
1 Like
I’m going to try and I’ll tell you 
I’m beginning to think that code is easier than no-code 
1 Like
Like anything there is a learning curve. You don’t just know everything you need to learn and fail and learn more just as with code and just as with life. Welcome to my TED talk lol.
2 Likes