Kapalı

Convert data from .csv email attachment to a new line in a google sheet

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.

Beceriler: Veri Girişi, Veri Tabanı Yönetimi, Google Cloud Platform, Sanal Asistan

Daha fazlasını gör: convert data pdf csv, convert sql data csv, convert yellow pages data csv, convert csv to google sheets, google sheets import csv from url, automatically import csv into google sheets, email csv to google sheet, google sheets import csv from drive, import csv to google spreadsheet script, auto import csv to google sheets, import csv into google sheets script, data entry, virtual assistant, database administration, csv, projects convert data pdf xls csv, convert sql data csv format, google app engine send email attachment, convert data pdf xls csv, convert tab data csv mac

İşveren Hakkında:
( 0 değerlendirme ) Sydney, Australia

Proje NO: #17816585

Bu iş için 47 freelancer ortalamada $346 teklif veriyor

jkaranm

Hi, My name is Janis and I have been here in freelancer since 2014. One of the preferred freelancer because of the good standing and have good feedback from previous employers. I was asked by the freelancer staff Case Daha Fazla

in %bids___i_period_sub_35% gün içinde588%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(54 Değerlendirme)
8.0
RSwapnil

I can update Google sheet daily from taking 2 columns as required from csv. How many emails containing csv file each day we received.

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(315 Değerlendirme)
7.7
mirniyazuddin92

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

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(351 Değerlendirme)
7.8
ponnarasiBabu

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

in %bids___i_period_sub_35% gün içinde294%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(400 Değerlendirme)
7.4
schoudhary1553

Hello, i have read your project details and i can help you with 100% quality and your satisfaction. I have delivered more than 400 project with client satisfaction. Please see my profile . I have more than 5 years o Daha Fazla

in %bids___i_period_sub_35% gün içinde350%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(195 Değerlendirme)
7.4
Dhruvika111

Dear Buyer, Do you want the CSV product file to be designed in Google sheet in such a way that the Google sheet gets linked to the CSV so that you can get updated based the information. Please let me know if I am not Daha Fazla

in %bids___i_period_sub_35% gün içinde277%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(321 Değerlendirme)
7.6
zekovicm

Hi there,I am Miljan,Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the ag Daha Fazla

in %bids___i_period_sub_35% gün içinde441%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(91 Değerlendirme)
6.9
ReliableMate

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..

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(117 Değerlendirme)
6.5
amirn2011

Hi, I am ready for your Convert data from .csv email attachment to a new line in a google sheet project. Already I have completed over 160 project in freelancer, especially in data entry, web research & also few c Daha Fazla

in %bids___i_period_sub_35% gün içinde352%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(132 Değerlendirme)
6.3
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best rega Daha Fazla

in %bids___i_period_sub_35% gün içinde500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(94 Değerlendirme)
6.0
tranngocanh1702

Hi, I am Anna with more than 6 years experience in web and cross-platform app development including Hybrid, PHP, Laravel framework, Slim, CodeIgniter, MySQL, PostgreSQL, HTML, CSS, Javascript, jQuery, Vuejs, Ajax, Daha Fazla

in %bids___i_period_sub_35% gün içinde440%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(35 Değerlendirme)
5.7
sonarkaushik

Sir, I am well versed in these kind of jobs and can do your project as per your requirement. I am very much able to work on this. ***I am ready to start Message me for further discussion. Waiting to hear from Daha Fazla

in %bids___i_period_sub_35% gün içinde277%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(132 Değerlendirme)
6.3
ianoc

Good day! I am interested in your project and absolutely confident I can get this job done better, faster and more neatly than anybody else here. I have over 15 years of experience in the IT industry and I have all Daha Fazla

in %bids___i_period_sub_35% gün içinde500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(23 Değerlendirme)
5.4
pilotarif

I can perfectly do your project work and able to complete full work in a shortest possible of time with 100% accuracy, perfection and according to your given instruction. I am ready to show you cost-free sample wo Daha Fazla

in %bids___i_period_sub_35% gün içinde277%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(40 Değerlendirme)
5.0
FerriSoft1

Hi, we already have done projects likes this one. What we offer is a Windows App where you select the .csv files, and then with 1 click, the information will be uploaded to the Google Sheet. Seting up the Google Daha Fazla

in %bids___i_period_sub_35% gün içinde388%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)
4.2
vsprybhanu

Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I can create google sheet from excel csv file through vba (macro). I have excellent knowledge and experience of Ma Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(26 Değerlendirme)
4.2
DesignerTarun04

Dear Hiring Manager, I have read your job description carefully and I’m very considering your job such as these capabilities. I have fantastic experience in this fields such as Data Entry, Admin Task, Website Task, Co Daha Fazla

in %bids___i_period_sub_35% gün içinde350%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(14 Değerlendirme)
4.1
WebInfoSolutions

any preference for the programming language?

in %bids___i_period_sub_35% gün içinde705%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(9 Değerlendirme)
4.1
techcristaglobal

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.

in %bids___i_period_sub_35% gün içinde441%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
3.4
ioanaprof

Dear Sir or Ms. I am John, pleased to meet you. I'm well experienced in Google Apps Script and G Suite. Please, take a look at my portfolio in my profile. All your requirements are achievable. Emails will Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)
3.3