Find Jobs
Hire Freelancers

Create script to pull data from multiple google sheets

$30-250 USD

Cerrado
Publicado hace alrededor de 7 años

$30-250 USD

Pagado a la entrega
This is very specific, please understand all the needs. I have a folder on google drive with google sheets files in it (xls) I want to have a script written that can scan a folder (this folder will change weekly based on date) This script will take the summary tab from each spreadsheet and put it into a master sheet. These will be done based on average 6 sheets per week Attached is the summary tab (most always starts at b11) COMMON NAME is the main field Attached is the Master sheet. You will see that the row header is sheet name, this would be very helpful as normally the sheet name is Fish Catch 03.03.17 I know scripts exist to help with this but I was not able to have the time to get it working [login to view URL] [login to view URL] Please respond specifically with time it will take, and what information you need. Anyone that doesnt provide a proper bid will be rejected.
ID del proyecto: 13336733

Información sobre el proyecto

24 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
24 freelancers están ofertando un promedio de $147 USD por este trabajo
Avatar del usuario
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$250 USD en 2 días
4,9 (358 comentarios)
8,0
8,0
Avatar del usuario
Dear Sir, Greetings for the day from Web Media Makers and trust you are doing well. We would like to thank you for giving us this opportunity to bid on your project. It will be really a great pleasure for us to work with you and serve you with quality of services in cost effective prices. Sir, we have gone through the requirement for your project. After going through all the details, we have some queries, which we would like to clarify with you. Can you please answer below queries for us to understand the requirement and scope of work properly before proceeding further on this: 1. Can you please share the list of required things? 2. Also, please share more details related to your project? Sir, We always try our best to satisfy 100% a client where as job is small or big and always try to deliver project in given timeline. Please review above and let us know your valuable thoughts and feedback. Have a good time and looking forward for your soonest reply to proceed further on this. Thanks Ved T Web Media Makers
$244 USD en 7 días
4,9 (96 comentarios)
7,4
7,4
Avatar del usuario
Hi Understood the details but I am not sure why the header says Name of Spreadsheet and the values are zeros. Could you please provide a proper before/after example? Looking forward to seeing your reply. Thanks. Regards Ahsan
$200 USD en 3 días
4,9 (98 comentarios)
6,8
6,8
Avatar del usuario
Hi there. My name is Daniel and I would be glad to help you out with this project. I can have the project done in no longer than a week, and initially with those 2 files that you attached is enough to get started. I would do all the testing with my personal google drive account, and then we can set it up to work with yours. I can guarantee an excellent job and deliver as soon as possible. Thanks
$199 USD en 7 días
4,8 (113 comentarios)
7,0
7,0
Avatar del usuario
Hi sir I am Hasan Jack and I have been doing PHP Development since last 5 years, so because of my relevant experience I really feel my self best fit for this website. Looking forward to hear from you to discuss project in further detail. Regards, Hasan Jack
$250 USD en 3 días
4,9 (56 comentarios)
6,3
6,3
Avatar del usuario
Hi, i'm a professional C# web bot programmer, and i can provide you with C# bot that will combine data from sheet in a regular basis, please provide me with more info if you are interested, thanks.
$150 USD en 3 días
5,0 (56 comentarios)
6,1
6,1
Avatar del usuario
Hello! My name is Warren Schultz, and I am a professional programmer with many years of data mining experience using Python. I have read your project description, and I can create the Google Sheets mining you have described. To do so, I will use the libraries Requests (for web automation tools), BeautifulSoup (for parsing html), and Selenium (for working with AJAX and Javascript). I have written very similar programs in the past, and I would be happy to show examples. Please contact me so we may speak further and so I can send files. Thank you for your consideration.
$155 USD en 3 días
4,9 (41 comentarios)
6,0
6,0
Avatar del usuario
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will give reference of my online work portfolio once I heard from you. I have all the resources ready to do your project as per your requirement I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
$194 USD en 3 días
4,6 (84 comentarios)
6,2
6,2
Avatar del usuario
- Went through the master list and the Fish Catch summary sheet. - Can get the script to extract the summary data from Fish Catch Summary and put them into the master list. - Have expertise in VBA scripting in Excel and Google sheet scripting. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Excel macros - I have done complicated data processing using Excel macros for Exam sheet evaluation, (Recent)Circuit designing based on mulitple wire models, amps/voltages, calculations of taxes for Canadian citizen based on tax slabs per Fed and Provincial tax, based on the salary ranges etc. - Outlook macros - - Samples - Extracting mail contents parsing and sending to different customers, getting the task and calendar events from Outlook to Excel - Pl. review my portfolio on recent projects.
$100 USD en 3 días
4,6 (53 comentarios)
6,0
6,0
Avatar del usuario
hello Iam a java developer highly skilled in data minning i red your description and i see that its a sort of organizing data extracted from some sheets to another lets clarify more the script you want to get and find you a good solution Thank you
$60 USD en 3 días
4,7 (39 comentarios)
5,5
5,5
Avatar del usuario
I know that Amit's scripts are awesome! But you will need someone to adjust his scripts for your needs :-) Hi there! I have done a very similar job recently. You can check its review under the title "From Google Drive to Google Sheets with some conditions". In that project, the client had an Excel file uploaded to a Drive folder everyday. He wanted a Google Script that runs daily, read the data in the xls file and add only the new data to the master Google spreadsheet. So for your script, we will have a time driven trigger that runs the script everyday, search the predefined Google Drive folder for xls files, opens every file, search the tabs that have the string "summary" in their names, read the data from these tabs and import the data into the master spreadsheet. We can also adjust it so when there is a row in the master spreadsheet have the same fish name as a row that we are importing from the other sheets, we can adjust the script to remove the old row and replace it with the new one, or add both rows as you will specify :-) The project will need 3 days to be completed!! I know that I have few reviews here, but all of them are related to Google Apps Script projects! I have started my freelancing career on Upwork. I'm a top rated freelancer with a job success score of 99% there. I'm trying to build a good profile here as well! I will be happy to address any of your questions! Cheers, Mohamed
$100 USD en 3 días
5,0 (27 comentarios)
5,2
5,2
Avatar del usuario
Hi Mygotobrandsinc, I am competitive to this kind of task, can take good care of this project. In fact, I already done related to this job before. Let me know the best of your time so we can discuss further based on your requirements and we can move forward to the next step. Thanks, Joseph C Ocero
$249 USD en 3 días
5,0 (23 comentarios)
5,0
5,0
Avatar del usuario
Hi I am here to assist u inthis project I am an ACCA member currently working in finance dept of Qatar Airways Have great skill and experience in Ms excel can assist u with high regards Plz share more info to proceed Thanks in anticipation Looking forward for this projext positively U can also review my profile for my clients reviews of my excel skills I can give u this in quick turnaround time
$150 USD en 2 días
5,0 (22 comentarios)
4,2
4,2
Avatar del usuario
Hi, I can do this project accurately and deliver in few days..................................................................
$30 USD en 1 día
5,0 (13 comentarios)
3,9
3,9
Avatar del usuario
Hi I'm a programmer with the skills in web design, development, software engineering, programming and graphics designing. I have been working in this area for last 5 years and completed quite a many projects for different organizations.
$155 USD en 3 días
4,4 (13 comentarios)
3,9
3,9
Avatar del usuario
Hello there! The scanning of the files on the google drive will not be a problem at all. Placing information from one spreadsheet to another is simple as well. One thing I couldn't understand is where and how you wish to name the rows in a Master file. However, I think we can figure this out during the chat. Let me know when you have time. Cheers, Denis
$244 USD en 3 días
5,0 (2 comentarios)
2,5
2,5
Avatar del usuario
Hello dear client, Am willing and ready to complete this for you within time. Am experienced guy in this as my line of study and therefore assuring you a 100% satisfaction of your work. Please consider my proposal and feel free to get in touch with me and lets start off. Kind regards, Isma Greg
$155 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de FIJI
Grandville, Fiji
5,0
13
Forma de pago verificada
Miembro desde sept 25, 2006

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.