Google Apps Script - Automated Spreadsheet Import

Pågående Publicerat 2 veckor sedan Betalades vid leverans

$250-750 AUD

Betalades vid leverans

Pågående Betalades vid leverans

Hi, I'm looking for someone who can write script to automate daily data importing from csv files into a google sheet.

We use a new google sheet each week to calculate production for each day, see example here:

[login to view URL]

We have two online platforms that we receive orders through, one for wholesale customers and another for retail customers.

For wholesale we use Ordermentum - www.ordermentum.com. To access the production reports we have to: 1. Open the "orders" page 2. Select the relevant delivery date 3. Export the production report for that date This data needs to populate into the relevant date column of the "ORDERMENTUM" tab in the google sheet. See sample production report attached ([login to view URL]) - this is for the items required by customers on Saturday May 4th. This data is not available to access without exporting it to a csv file.

For retail orders we use Shopify but use two apps to provide the data to our production team so that they know when the customer has selected to pick up their order - Zapiet Pick + Delivery to assign an order pickup/delivery date (it does so by adding date tags to orders) and Report Pundit to organise this information into production reports. See an example Report Pundit export for Sunday May 5th (Production - Daily [login to view URL]) This data needs to populate into the relevant date column of the "SHOPIFY" tab in the google sheet.

All of our products have SKUs assigned which also populate in the reports, I'm now adding these to our google sheet as I assume they will be necessary for correctly assigning the data. See sample reports attached - the one ending in "new_" is the retail report, the other the wholesale report.

I need the final process to be simple for my kitchen team to use ideally with a user interface where they can complete the data import without accessing code, they will select the date that the product in each report relates to, whether it's wholesale or retail, and upload the report.

Happy to negotiate rate as I'm not certain of the size of this project.

JavaScript PHP Google Chrome Programvaruarkitektur Google Apps Scripts

Projekt-id: #38067638

About the project

35 offerter Distansprojekt Aktivt förra veckan

Skulle du vilja tjäna pengar?

Fördelar med att lägga anbud på Freelancer

Ställ in budget och tidsram

Få betalt för ditt arbete

Skissa på ditt förslag

Det är gratis att registrera sig och lägga bud på jobb

Tilldelades:

writingapp

(221 omdömen)

7.1

35 frilansare har lagt bud på i genomsnitt $493 för det här jobbet

AwaisChaudhry

Hello Good morning , I just finished reading the job description and currently going through attached files . I see you are looking for someone experienced in developing products using PHP, Google Chrome, Software Arc Mer

$750 AUD inom 13 dagar

(150 omdömen)

8.8

ahmadayaz

With over a decade of experience in Full Stack Development, WordPress, Mobile App Design, and more, I have a stellar track record of delivering successful projects for both enterprise and medium-tier organizations. I e Mer

$675 AUD inom 5 dagar

(316 omdömen)

8.7

lkhelladi

Hello, I'd be glad to develop a sotware with simple user interface allowing you automatic data import from CSV into googlesheet. Looking forward to chat with you soon for more details. Best regards.

$720 AUD inom 3 dagar

(157 omdömen)

7.8

ayesha0124

Hello there, The skills PHP, Software Architecture, JavaScript, Google Chrome and Google Apps Scripts u mentioned on the project fall under my level of expertise so i can surely help u with it. Please have a look at my Mer

$750 AUD inom 7 dagar

(22 omdömen)

6.7

techcity

Hi, So basically you are using multiple apps and manually processing + updating data in the Google sheets. Let's start with retail. If we completely automate the process, I don't think we need Zap or Report Pundit ap Mer

$750 AUD inom 10 dagar

(36 omdömen)

6.9

mohamedgb00714

Hi I can create for you this script contact me and let's start the work right now regards Mer

$500 AUD inom 7 dagar

(125 omdömen)

6.3

Giovanni704

Hi there! As I have read, I see you need help automating the daily data importing process from CSV files into a Google Sheet, and I could help you! I will develop a script to automate the daily importing of data from Mer

$250 AUD inom 1 dag

(16 omdömen)

5.5

ytpaussie

Hi We would love to create a script to automate daily data importing from csv files into a google sheet. We have read and understood the details. We are an experienced and versatile IT professionals with more than a de Mer

$500 AUD inom 7 dagar

(14 omdömen)

5.3

Nilufer2024

Hi, ! I have worked with similar projects so that I can provide you with a satisfied result. Having confirmed the job posting " Google Apps Script - Automated Spreadsheet Import", I truly feel that you're looking for Mer

$400 AUD inom 5 dagar

(5 omdömen)

4.7

Kiranfreelancer8

Hi I have 4+ years of experience with python. I can make this data feed work done in few hours and deliver you the best quality work. Contact in my private message box for more details.

$250 AUD inom 1 dag

(29 omdömen)

4.7

souyah

Hi, there! Having confirmed the job posting, it seems like you might be looking for a senior developer for your project - Google Apps Script - Automated Spreadsheet Import. I have worked with similar projects so that Mer

$555 AUD inom 2 dagar

(5 omdömen)

4.0

rahmatginanjar

As an expert in Google Apps Scripts, I possess a unique blend of technical proficiency and data management expertise that makes me the perfect fit for your project. With over 5 years of experience in Excel VBA, I'm wel Mer

$250 AUD inom 3 dagar

(2 omdömen)

0.8

escalantejoaquin

Hello haylzt I would like to grab this opportunity and will work till you get 100% satisfied with my work. I'm an expert full-stack developer which have 6+ years of experience on PHP, JavaScript, Software Architectur Mer

$500 AUD inom 7 dagar

(0 omdömen)

0.0

luis00701

Hello , This is Enrique. Hope you are doing well. I'm very interested in your project since I'm very confident in Google Chrome, PHP, Software Architecture, Google Apps Scripts and JavaScript. As a experienced develop Mer

$500 AUD inom 4 dagar

(0 omdömen)

0.0

ichaina

Hi haylzt, I would like to grab this opportunity and will work till you get 100% satisfied with our work. I have over 6 years of experience on PHP, JavaScript, Software Architecture, Google Chrome, Google Apps Script Mer

$500 AUD inom 7 dagar

(0 omdömen)

0.0

khalidbo

Hello, I am Khalid, a mobile engineer ready to begin work on your project immediately. With strong skills on automatization app development and a commitment to quality, I can ensure efficient and effective results. Ple Mer

$250 AUD inom 2 dagar

(0 omdömen)

0.0

Rockstardevs11

Hi !!! GIVE ME A CHANCE! I CAN DO YOUR PROJECT PERFECTLY! I read your job description and fully understood it. I have experience completing similar projects like this. If you hire me, I will provide the best service in Mer

$700 AUD inom 7 dagar

(0 omdömen)

0.0

raheesmuh

Experienced web developer proficient in PHP, JavaScript, and Google Apps Script, offering expertise in automating daily data import tasks from CSV files into Google Sheets. With a strong foundation in software architec Mer

$500 AUD inom 4 dagar

(0 omdömen)

0.0

vuica6

Hi, I am excited about the opportunity to assist you with automating the daily data importing process into your Google Sheets from CSV files. Based on the detailed requirements you've provided, I am confident that I c Mer

$450 AUD inom 5 dagar

(0 omdömen)

0.0

Lägg upp ett liknande projekt

Google Apps Script - Automated Spreadsheet Import

About the project

Skulle du vilja tjäna pengar?

Fördelar med att lägga anbud på Freelancer

Tilldelades:

35 frilansare har lagt bud på i genomsnitt $493 för det här jobbet

Frilans

Om

Villkor

Appar