Google App Script: Copy an existing spreadsheet and transfer a set of cell values to the copied version.

$30-250 USD

Terminado

Publicado

hace 3 meses

$30-250 USD

Pagado a la entrega

In the spreadsheet named 'X' (Yes, that is indeed its actual filename), create a new menu called "Upgrade to New Verkflo" The script copies another spreadsheet, renames the copied spreadsheet, moves the copied spreadsheet to a different folder, and then copies a list of cell values from another spreadsheet to the copied spreadsheet. The spreadsheet being copied is called "Verkflo 22-2-2024" It must be copied to a new folder in Google Drive. That is identified by looking at the sheet ID that is stored in Cell C1. Move the copied sheet to the same folder as the sheet whose ID is in Cell C1. Rename the copied spreadsheet by taking the name that is in Cell B1 and joining it with the file name of the newly copied spreadsheet. For example the Cell C1 value is "Joe Bloggs" and the name of the new spreadsheet is "Copy of Verkflo 22-2-2024", the new spreadsheet file name should be renamed "Joe Bloggs Verkflo 22-2-2024". Now copy the list of Cell values given below from the spreadsheet whose ID is in Cell C1 over to the newly created spreadsheet. B2, C2 D2 C3 C4 D7 B8 B9 B10 B11 B12 B13, C13 B14 B15 B16 B17 B18 B19 B21 B22 B23 B24 B25 B26 B28 B29 B30 B31 B32 B34 B38 B39, C39 B40 B41 B42 B43 B45, C45 B46 B47, C47 B48 B49, C49 B50, C50 B51 B52, C52 B53, C53 B54 B55, C55 B56 B57, C57 B58, C58 B59, C59 B60,C60 B61, C61 B62 B63, C63 B65, C65 B66 B67, C67 B68, C68 B69 B71, C71 B72 B73, C76 B77 B78, C78 B79 B80, C80 B81, C81 B82 B84, C84 B85 B86 B87 B88 B89 B90 B91 B92, C92 B93 B94, C94 B97 B98 B99 B102, C102 B103 B104 B105, C105 B106, C106 B107, C107 B108, C108 B110, C110 B111, C111 B112, C112 B113 B114, C114 B115 B117, C117 B118 B119, C119 B120, C120 B121 B122, C122 B123, C123 B125, C125 B126 B127 A129, B129, C129, G129 A130, B130, C130, G130 A131, B131, C131, G131 A131, B132, C132, G132 A137, B137, C137, D137 A138, B138, C138, D138 A139, B139, C139, D139 A140, B140, C140, D140 A141, B141, C141, D141 A142, B142, C142, D142 A143, B143, C143, D143 A144, B144, C144, D144 A145, B145, C145, D145 A146, B146, C146, D146 A147, B147, C147, D147 A148, B148, C148, D148 A149, B149, C149, D149 A150, B150, C150, D150 A151, B151, C151, D151 B155 B156 B157, C157 B158 B159 B162 B163 B164 B167, C167 B168 B170 B171, C171 B172 B174 B175, C175 B176 B178 B179, C179 B180 B182 B183, C183 B184 B186 B187, C187 B188 B190 B191, C191 B192 B183 B194 B196 B201 B202 B204, D204, G204 B206, C206, D206, E206 B207, C207, D207, E207 B208, C208, D208, E208 B223 B224 B225 B227, C227 B228, C228 B229, C229 B230, C230 B231, C231 B232, C232 B233, C233 B234, C234 B235, C235 B236, C236 B237, C237 B238, C238 B239, C239 B240, C240 B241, C241 B242, C242 B243, C243 B244, C244 B245, C245 B246, C246 B250, C250 B251, C251 B252, C252 B253, C253 B254, C254 B255, C255 B256, C256 B257, C257 B258, C258 B259, C259 B260, C260 B261, C261 B262, C262 B263, C263 B264, C264 B265, C265 B266, C266 B267, C267 B268, C268 B269, C269 B287 B299 B300 B301 B309 C310 B313 B348, C348 B349 B351 B352, C352 B353 B355 B356, C356 B357 B359 B360, C360 B361 B363 B364, C364 B365 B367 B372, C372 B373 B375 B376, C376 B377 B379 B380, C380 B381 B383 B384, C384 B385 B387 B388, C388 B389 B391 B392, C392 B393 B395 B396, C396 B397 B399 B400, C400 B401, C401 B403 B413 B414 B415 B416 B417 B419 B424, C424 B425, C425 B456 B460 A486, B486, C486 through to A516, B516, C516 B575 B576 B577 B578 B579 B580 B581 B582 B583 B584 B585 B586 B587 B588 B589 B590 B591 B592 B593 A801, B801, C801, D801, E801 through to A999, B999, C999, D999, E999 Job done!

ID del proyecto: 37795669

Información sobre el proyecto

47 propuestas

Proyecto remoto

Activo hace 3 meses

¿Buscas ganar dinero?

Dirección de email

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

Adjudicado a:

@rahul62544

$0 USD en 1 día

5,0

(911 comentarios)

8,7

47 freelancers están ofertando un promedio de $148 USD por este trabajo

@ahmadayaz

With over a decade of experience in Full Stack Development, WordPress, Mobile App Design, SAAS, and Corporate Branding, I have a proven track record of delivering successful projects to organizations. Let's discuss your project requirements in detail to bring your ideas to life efficiently. Key points to clarify include: 1. Reason for creating "Upgrade to New Verkflo" menu in 'X' spreadsheet. 2. Specifications for the folder where the copied spreadsheet will be stored in Google Drive. 3. Preferred timeline for project completion. Once I have these details, I can provide a more accurate timeline and budget estimate. Looking forward to working together on this exciting project!

$225 USD en 5 días

5,0

(311 comentarios)

8,7

@schoudhary1553

I am Sandeep, with over 7 years in this field; my expertise lies in Excel and JavaScript, both of which will be crucial for your project. My background includes working with top companies like Metlife GOSC, DXC Technologies, and Elite Services where I have developed a wide range of web-related skills relevant to your needs. Specifically, I have a deep familiarity with Google Spreadsheets and have completed several projects involving the use of App Scripting for spreadsheet manipulation; that commands a high level of precision which I have consistently delivered. I strongly believe that the challenge your project presents would not only permit me to leverage on my existing skills but equally stretch it to produce more efficient codes. Moreover, I have extensive knowledge of PHP- a web development language that could potentially be useful in addressing any additional script requirements or complications beyond the scope you've already outlined. My goal is to give you the best result achievable within the set time frame by combining utmost speed with excellent quality. Let's proceed, and I promise you won't regret choosing my services.

$180 USD en 5 días

4,9

(630 comentarios)

8,6

@techplusintl

Hi there, ★★★ Google Apps Script / Sheets / Forms / VBA Expert ★★★ 6+ Years of Experience ★★★ I've read requirements and ready to copy an existing spreadsheet and transfer a set of cell values to the copied version.. I am capable of developing both script-based and formula-based spreadsheets, as well as anything related to Google Services, Integration, and Automation. My Services: ✔️ Google sheets automation ✔️ Google Form, Google Docs, Apps ✔️ Google apps script ✔️ Automate google calendar ✔️ Creating bulk google calendar events from google sheet ✔️ Auto-generate reports from google sheets ✔️ Gmail automation (Auto send or delete emails from Gmail) ✔️ Integration of all Google services (spreadsheets, calendar, maps, Gmail, etc.) and other third-party APIs ✔️ Dashboard design and automation ✔️ Formulas, Fix your data, Filters, Queries ✔️ Conditional formatting, Crush Duplicates ✔️ REGEX, Countif, VLookup, Hlookup, Index Match ✔️ Interlinking Sheets or other Google sheets sheets ✔️ Importing Data from Websites and other Google Sheets ✔️ Manage Drive From Sheet ✔️ Pivot charts, Pivot Tables, Dashboards As the requirements on project are not complete and need discussion so i placed tentative bid. To provide you the best quote, let's have a chat! Best Regards, TechPlus Team

$250 USD en 2 días

4,8

(351 comentarios)

8,1

@einnovention

As an experienced member of a 25-person team, I have successfully completed over 248 projects on Freelancer.com, giving me an excellent track record and a profound understanding of what it takes to deliver exceptional results. When it comes to working with Google Apps Script, I am your go-to guy. I am well-versed in JavaScript and have ample expertise in Excel, having utilized it extensively throughout my career to handle large amounts of data like the one at hand. My knowledge and experience combined make me the perfect candidate for this project. Not only do I offer unlimited revisions until you are fully satisfied with the result, but my service is also free for over two weeks after completion. This means that if you have any tweaks or updates after the project's delivery, I've got you covered at no additional expense. I also provide free consultation services before hiring to ensure that we create a flexible plan that best suits your needs. In addition to my technical proficiencies, I understand the significance of clear communication and swift turnarounds. Your project won't just be another task for me, but rather an exciting opportunity to showcase my skills and add yet another success story to my portfolio. Reach out to me today so we can start transforming your vision into reality with absolute precision!

$120 USD en 7 días

4,9

(183 comentarios)

7,7

@akritisood94

With a comprehensive grasp of Excel and Google App Engine and a strong proficiency in JavaScript and PHP pro-eminence, I'm the perfect candidate for your project on Google App Script. For years, I've been helping businesses automate their data processes to enhance efficiency and accuracy. This entails tasks like copying spreadsheets with new names, transferring files between Google Drive folders, and updating value cells as detailed by your project. You can rely on me to not only deftly copy all necessary cell values from the designated spreadsheet but also rename and move the copied spreadsheet to the correct folder as outlined in your job description - it's all in a day's work for me. Moreover, I am diligent about incorporating minor details that make a massive difference such as joining Cell B1 with the copied spreadsheet's filename when renaming it. With my proactive outlook towards tackling repetitive tasks using automation, your productivity is bound to increase significantly. I'll ensure that once this script is up and running, you won't have to lift a finger for these specific operations at any point in the future. Your project seems exciting and challenging – two aspects I relish. Do join me in this journey of creating a truly remarkable solution that enhances your workflow! To get started – click on the Hire Me blue button on the right!

$140 USD en 2 días

4,9

(322 comentarios)

7,4

@Devrits

Hey! I am an expert PHP software engineer with skills including Google App Engine, PHP, Excel and JavaScript. Expert PHP Developer | CodeIgniter, Laravel, WordPress 10+ years building web solutions, from scratch to scalable backends. Top Rated freelancer committed to efficient, reliable results. Skills: PHP (OOP), MySQL, HTML5, CSS3, JS (jQuery) WP themes/plugins, customization, optimization Laravel, CodeIgniter: Rapid dev & scalability Full-Stack Web Dev from scratch RESTful APIs, SOAP, JSON, XML Database design & SQL optimization CI/CD, PHPUnit test coverage Huge file parsing & continuous database updates Data mining, website scrapers Git (GitHub, GitLab, BitBucket) Cron Jobs & queues Caching: Files, Memcached, Redis ML, Data Analysis, Neural Networks Agile development methodologies Troubleshooting, bug fixing, performance optimization Strong problem-solving & analytical skills Services: Full-Stack Web Dev: Custom websites (PHP, MySQL, Bootstrap) WordPress: Themes, plugins, tailored solutions PHP Framework Dev: Laravel/CodeIgniter for complex, scalable projects Admin Panels: User-friendly, streamlined data management API Integration: RESTful, SOAP, JSON, XML Database Design & Optimization: Efficient structures, smooth data management Customization & Integration: Third-party tools, payment gateways, extensions Bug Fixing, Maintenance, Support: Keep your website running smoothly Code Review & Refactoring: Improve quality, maintainability, performance Looking for a dedicated PHP expert to bring your ideas to life? Let's connect! Please send a message to discuss more about this project. Thanks

$150 USD en 3 días

4,7

(111 comentarios)

7,1

@DevBench

Hello. I am an experienced Google Apps Script developer with expertise in spreadsheet automation. I am confident that I can help you automate the tasks described in your project. To clarify the requirements, I kindly request the following information: 1. Can you provide the exact folder path where the new spreadsheet should be created? 2. Are there any specific naming conventions for the copied spreadsheet and folder? 3. Do you have a preference for how the copied spreadsheet should be formatted? 4. Is there a specific trigger or event that should initiate the copying process? Let's have a quick chat session so we can discuss the automation process thoroughly. I look forward to connecting with you to discuss further.

$180 USD en 2 días

5,0

(20 comentarios)

5,9

@arunkumar9896

As an experienced Excel professional with a focus on data analysis and automation, I have spent several years honing my skills in utilizing the advanced features of Microsoft Excel, including VBA/Macros, to develop effective solutions for complex tasks. I understand the specific requirements of your project and am well-equipped to tackle it head-on to deliver sophisticated results. Given this is a Google App Script task, you can rest assured - I am highly skilled and experienced in Google Sheets as well. My skill set transcends beyond Excel and Google Sheets. As an Adobe Acrobat expert, I can also assist with making any files fillable or handle editing and scripting if needed. This comprehensive expertise allows me to provide robust and integrated solutions that maximize efficiency and minimize chances of error. Moreover, my commitment to delivering high-quality work within the agreed-upon timeline will ensure your project is completed promptly without any compromise on quality. Your satisfaction is paramount to me, and I guarantee clear communication, attention to detail, and a strong work ethic throughout our collaboration. With Arun Kumar Gupta by your side for this task, you are guaranteed professional handling of your valuable data with utmost precision and confidentiality. I look forward to working with you soon!

$85 USD en 1 día

5,0

(44 comentarios)

5,6

@Demenntor

Dear Client, I am excited to submit my bid for your project. I propose to create a new menu named "Upgrade to New Verkflo" in the spreadsheet titled 'X'. This menu will facilitate the execution of a script that performs the following tasks: 1. Copying another spreadsheet. 2. Renaming the copied spreadsheet. 3. Moving the copied spreadsheet to a designated folder. 4. Copying a list of cell values from another spreadsheet to the copied one. With my expertise in Google Apps Script and spreadsheet automation, I will ensure seamless integration and functionality. I am committed to delivering a high-quality solution that meets your requirements effectively. Looking forward to the opportunity to work together. Regards, Lalit

$240 USD en 7 días

4,9

(23 comentarios)

5,1

@tukabwanausi

To successfully execute the automation of your spreadsheet processes, it's crucial that I'm granted the necessary access permissions. The job entails: Access Permissions Required: Edit Permissions for Specific Spreadsheets: This includes the primary "Verkflo 22-2-2024" spreadsheet and any others involved in the process that will either share or receive data. Google Drive Folder Access: Permission to add, move, and rename files within the designated Google Drive folder. This is where the newly created spreadsheet will be stored according to your project details. With these permissions, I can proceed to write and implement a custom Google Apps Script. This script will automate the tasks of duplicating the "Verkflo 22-2-2024" spreadsheet, placing it in the correct folder, and organizing the data as needed. Granting these access permissions is pivotal for me to complete the job. With full access, I can ensure the automation process is set up correctly, leading to a more efficient and streamlined workflow for you. I'm ready to start this project once the necessary permissions are in place.

$140 USD en 7 días

4,9

(12 comentarios)

4,5

@habib1433

Hello sir, This is Habib. Today I will finish your previous task, I want to also get the task. And it will also complete within 1 day. I hope you will also accept the request. Thank you. Have a great day. -Habib

$80 USD en 1 día

4,9

(25 comentarios)

4,2

@dillonmarszal

Hello. I am a SR. WEB DEVELOPER who can certainly make your idea into real! I have enough experience in Google App Engine, JavaScript, PHP and Excel. I am waiting your reply here, please don't hesitate contact me anytime. Thanks.

$200 USD en 7 días

5,0

(5 comentarios)

3,8

@webexpertvicky13

With over 6 years of experience as a full-stack web developer, I come equipped with an extensive skill set comprising PHP, HTML5, CSS, JS, and WordPress which are exactly the kind of skills required for this project. I have worked on numerous projects involving data migration and manipulation as well as script-driven automations just like this one proposed by you. Alongside, I have comprehensive knowledge of Google App Scripting which will ensure coding quality and efficient project execution without any compromise. Having designed responsive websites, developed web APIs, incorporated payment systems, created backend algorithms for web crawlers and automated bots; I'm confident that I can fulfill your requirement pertaining to copying files, file renaming, file handling in Google Drive folders as well copying your designated list of cell values with 100% accuracy that too within a stipulated time frame. Moreover, I can assure you of maintaining clear turnaround time with prompt and consistent communication throughout the project life cycle. My ultimate aim is client satisfaction which I execute by delivering professional grade output emphasising on quality- offering value for money invested. To sum up, if you're looking for someone who understands the task, has relevant experience and can deliver swiftly while maintaining accuracy then you should consider me as your top candidate for your valuable project. Let's get to work and achieve productive results!

$250 USD en 7 días

5,0

(20 comentarios)

3,8

@GdevDataSceince

Hi there, I am a Data Scientist a professional responsible for extracting actionable insights and knowledge from large volumes of data GOOGLE SHEET Development. I can write clean Google Sheets, Google Excel Sheets, Power BI, Outlook, and Google VBA macros. Google Excel: Advanced Array Formulas, Charts, Pivot Tables, Pivot Charts, Mail Merge, VBA Macros, Excel Macros, Capabilities, Spreadsheets. Email through Outlook and Gmail, Add-in, Customized Macros. My top priority is to provide high-quality work, I am willing to fully devote my time and energy to improve the service offered, with timely, accurate, and professional results, building trust and a long-term relationship with customers is my main objective. https://www.freelancer.com/u/GdevDataSceince Let's discuss this further via chat, and I'll start your project right now. Thanks Gdev

$140 USD en 7 días

5,0

(8 comentarios)

4,0

@syedraza21295

Hello Jason B., We would like to grab this opportunity and will work till you get 100% satisfied with our work. We are an expert team which have many years of experience on PHP, JavaScript, Excel, Google App Engine Please come over chat and discuss your requirement in a detailed way. Regards

$90 USD en 2 días

5,0

(5 comentarios)

3,4

@xamling

Hi! I have experience working with GAS. I am confident I can handle the job in a short time. Hopefully we can work together. Thank you!

$30 USD en 1 día

5,0

(11 comentarios)

3,4

@angelgrod

Hello, I've checked your project description right now. I really excite for your project purpose. Because I have build a complex google apps script project before, so I can finish project asap in according to your requirements. Please contact me for more discussion. Thanks for job posting.

$150 USD en 2 días

5,0

(5 comentarios)

3,1

@topgan1994

Hello, Jason B. I am very interested in your project "Google App Script: Copy an existing spreadsheet and transfer a set of cell values to the copied version." and I believe that my skills and experience make me a strong candidate for this job. I am proficient in Excel, Google App Engine, JavaScript and PHP and am committed to delivering results that exceed your expectations. I am confident that I can deliver high-quality work within the specified timeframe. I am available to start immediately. Please feel free to contact me to discuss the project in more detail. Best regards, Ihor

$140 USD en 4 días

5,0

(1 comentario)

2,8

@siedovyehorrr32

Hello I’ve carefully checked your requirements and really interested in Google App Script: Copy an existing spreadsheet and transfer a set of cell values to the copied version.. I am confident for your project because I have skills of JavaScript, Google App Engine, PHP and Excel. I’m ready to discuss your project and start immediately. Looking forward to hearing you back and discussing all details. Sincerely, Yehor.

$150 USD en 1 día

5,0

(1 comentario)

2,6

@fikir75

With a multi-dimensional skillset in web and mobile development, particularly in JavaScript and PHP, I believe I'm the perfect fit to automate your complex Google App Script task. Having developed numerous API's and working knowledge of scrapping data using Python, I'm confident in my ability to copy and transfer the set of keys from spreadsheet 'Verkflo 22-2-2024' to the newly created spreadsheet. In conjunction with your script requirements, my understanding of Database Design using MySQL, PostgreSQL, and NoSQL such as MongoDB and DynamoDB will be helpful throughout the process. Furthermore, My DevOps and Agile management competencies ensure that not only the tasks will be completed promptly, but they will also be scalable and efficient. Last but not least, my experience in using languages such as Xamarin React Native Swift Flutter Ionic etc for developing a robust mobile platform can prove of use should you need any further assistance at the crossroads of this spreadsheet project with mobile applications. Together, we can ensure all your goals are met within deadline. Choosing me would be choosing proficiency, dedication, and results. Let's talk!

$140 USD en 7 días