Every day I receive an email with a .csv file attached. What I want to do is add those cells to a spreadsheet that I have in Google Sheets.
So far I added the watch emails module, then the iterate attachments and the add row to google sheets.
I can see the data from the .csv file but then I dont know what to do to map the values and then send it to google sheets
How can achieve this?
Thx in advance
You can use a CSV “Parse CSV” module with the data.
Omg that was to easy :v ty so much.
Any advice on how to create a new sheet for each month?
No problem, glad I could help!
1. If you have a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.
2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.
This marks the topic as solved, so that:
others can save time when catching up with the latest activity here, and
To do this, simply click the checkbox at the bottom of the post that answers your question:
3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!
