Skip to main content

I’ve gone through multiple posts and google but I just can’t figure out how to manage what I need. I’ve seen the Formatter and Loopings mentioned but I’m clueless as to how to accurately set things up.

This is what I want to do:
1. Extract CSV attachment from Outlook email (this works)
2. Import CSV File with the formatter (also works I think?)
3. Delete the first 11 rows from the CSV
4. Remove the text ea from a column
5. Change the , symbol to .
6. Upload the adjusted csv to dropbox

Can someone please walk me through this?

This is what the CSV import looks like:
To give some clarification, I only need the 2 columns, Product ID and Free Stock with their values in the final CSV file.
I’m not sure where the text ‘Week’ comes from in between those.

 

And this is what the imported CSV attachment looks like, we have no way of changing this in the program that outputs this information unfortunately.
 

 

Hi @MartineHBM 

Based on what you’ve described you’d actually need to do API requests on a spreadsheet to generate a revised spreadsheet to then upload.

GSheets API can be used for this, but that is a much more advanced approach, than what is supported with the GSheets Zap actions.

GSheets API: https://zapier.com/apps/google-sheets/integrations#triggers-and-actions

 

Hi @MartineHBM 

Based on what you’ve described you’d actually need to do API requests on a spreadsheet to generate a revised spreadsheet to then upload.

GSheets API can be used for this, but that is a much more advanced approach, than what is supported with the GSheets Zap actions.

GSheets API: https://zapier.com/apps/google-sheets/integrations#triggers-and-actions

 

Thank you for your quick response Troy!
This sounds like something beyond my abilities, I will see if I can find someone to set this up for me. :)

@MartineHBM 

Directory of Certified Zapier Experts: https://zapier.com/experts

Reply


Terms & Conditions