Google Apps Script - Automated Spreadsheet Import
$250-750 AUD
Paid on delivery
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.
Project ID: #38067638
About the project
Awarded to:
35 freelancers are bidding on average $493 for this job
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 More
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.
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 More
Hi I can create for you this script contact me and let's start the work right now regards More
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 More
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 More
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.
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 More
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 More
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 More