We have several stores that all use the same Point of Sale software (Junction 6). This software has been configured to generate and email a daily sales report once every 24 hours that attaches as a .csv breakdown of sales every day. We would like this dropped into a Google Sheet so that we can have an Automatic Daily updated report (dashboards are linked to this Google Sheet).
The output required is:
Column A: Date
Column B to F: Product Sales
Then each day, a new line gets added to the bottom of the Google Sheet when the email comes through
There are only 18 different products and this will not change
I only need the Data in Column B and Column E of this spreadsheet.
46 freelancers are bidding on average $348 for this job
I read and understood your requirements and would like to discuss more about the project. So i hope you would open a PM to discuss about the work . Regards, Ponsi
Hi there, I can convert data from .csv email attachment to a new line in a google sheet. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
Understood, Need to grab details of the products from the CSV file and save them into the Spreadsheet. Will get this done with complete attention to details..
Do you want manually that you are going to CSV to google sheet daily and want a dashboard for the same ? Or dashboard require to fetch emails csv and strore it to dashboard.