Find Jobs
Hire Freelancers

Google Apps Script Macro Dev

$30-250 AUD

Suoritettu
Julkaistu noin 2 kuukautta sitten

$30-250 AUD

Maksettu toimituksen yhteydessä
Hi, I require a proficient freelancer to craft a Google Apps Script (GAS) macro compatible with Google Sheets, aiming to automate the merging and synchronising of information from two independent customer databases. Specifically, the macro should flawlessly merge and compare the following items: - Names - Email addresses - Phone numbers Additionally, the macro should also handle other fields relating to both companies and individuals. These fields include plus other fields - Addresses - Job titles - Company names - LinkedIn profiles - Mobile phone numbers - Social media handles - Website URLs - Industry/Category - Segment - Personalised notes - Required actions - Plus other fields 1. This macro will automate the process of merging and comparing data from two separate customer databases within our sheets. Additionally, it will identify and highlight potential duplicate entries for manual review. 2. Analyse the provided information to understand the structure of both customer databases (column headers, unique identifiers). 3. Develop a macro script using Google Apps Script that performs the following tasks: Merges data from both sheets based on a chosen strategy (combine all data or prioritize a specific sheet for conflicts). 4. Compares data points within merged rows and identifies potential duplicates based on defined criteria (unique identifier only or additional criteria like name and address). 5. Highlights identified duplicate rows with a specific marking for easy visual identification. 6. Ensure the script is well-commented and documented for future reference and maintenance. 7. Provide clear documentation instructions for users on how to utilise the macro (triggering method, sheet names, etc.). 8. Test and install the script thoroughly on a copy of the data before deployment to avoid unintended consequences. Qualifications: The ideal freelancer for this task should be highly experienced in Google Apps Script and Google sheet database management, with an eye for detail to ensure accuracy in merging and comparing data. A solid understanding of Google Sheets and an ability. Proven experience with Google Sheets and Google Apps Script. Strong understanding of data manipulation techniques and scripting logic. Excellent communication and documentation skills. Completion time is ASAP, thus a demonstration of previous works done quickly, efficiently but similar to our requirement would be advantageous.
Projektin tunnus (ID): 37830300

Tietoa projektista

19 ehdotukset
Etäprojekti
Aktiivinen 2 kuukautta sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
Myönnetty käyttäjälle:
Käyttäjän avatar
$0 AUD 7 päivässä
5,0 (72 arvostelua)
5,2
5,2
19 freelancerit tarjoavat keskimäärin $173 AUD tätä projektia
Käyttäjän avatar
As the CEO and founder of Digital Screencast with over 7 years of experience as a full-stack developer, I have developed a robust skill set that aligns perfectly with your project requirements. I have a proven track record in Google Apps Script, which includes Google Sheet databasing, web scraping, and web automation. I am well-versed in data manipulation techniques and scripting logic - crucial skills for merging and comparing data from two independent databases proficiently. Furthermore, my work history with top companies such as Metlife GOSC, DXC Technologies, and Elite Services has instilled in me an unyielding commitment to accuracy. I am meticulous in understanding data structures and have a keen eye for detail to ensure a seamless integration of your customer databases. My well-commented and thorough documentation ensures the script can be effectively utilized by your team long-term. In summary, with my extensive skillset in Google Apps Scripting, Google Sheets & Excel formulas, VBA macros etc. along with my drive for speed, accuracy and client satisfaction, I am certain I can deliver an exceptional solution that will greatly streamline your data management processes. Let's collaborate!
$180 AUD 4 päivässä
4,9 (634 arvostelua)
8,6
8,6
Käyttäjän avatar
Hi there, I'm thrilled to apply for your Google Apps Script Macro Dev project. With 4-5 years of experience in Google Sheets, Web Scraping, Google Apps Scripts, Python and Excel, I'm confident in my ability to bring valuable insights and expertise to your initiative. Please note that the initial bid is an estimate, and the final quote will be provided after a thorough discussion of the project requirements or upon reviewing any detailed documentation you can share. Could you please share any available detailed documentation? I'm also open to further discussions to explore specific aspects of the project. Feel free to check out my profile, showcasing my portfolio, past jobs, and client reviews. It reflects the quality and professionalism I bring to every project. My goal is to provide a competitive budget without compromising on quality. Thanks for considering my proposal. I'm eager to collaborate and contribute to your project's success. Let me know if you need any more information. Best regards, Rashid Amjad
$250 AUD 8 päivässä
5,0 (11 arvostelua)
5,2
5,2
Käyttäjän avatar
I’m a professional Engineer who has spent the past 7 years building, developing, and perfecting systems (from the ground up) through Google Sheets. With over 30 years of experience in the industry, I’ve not only learned how to develop, but how to work with clients, and I pride myself on bringing my clients high-end solutions and lifetime support. I’m incredibly well-versed in Google software, including: ● Google Sheets ● Google Apps Script ● Google Forms ● Google Data Studio Through this expertise, I’ve created some strong assets that I’m happy to share with you if you’re interested in pursuing my professional portfolio. If you’re looking for an Engineer who can develop through Google software fast, efficiently, and with great results, I’m the person for you. So please, reach out with your questions and project needs, and we can get started. Please view what my employers have to say : https://www.freelancer.com/u/aruls1962
$200 AUD 7 päivässä
4,9 (19 arvostelua)
4,2
4,2
Käyttäjän avatar
Hello Boss, I've been working as a Google Apps Script Developer in a US-based startup for lead generation. I've been developing lots of things such as a Bulk Email Sending Bot and calculating distance between leads via Google Maps API, filtering and managing lots of leads. Literally, I got through each point you mentioned :DD Let's have a quick to discuss this further
$140 AUD 7 päivässä
5,0 (2 arvostelua)
3,1
3,1
Käyttäjän avatar
Hello, Let me help you with the automation of your workflow processes with google Appscript and macro. I can help to automate your spreadsheet workflow process to Identify, highlight and Merge duplicate data on your sheets. I can guarantee you that the script will run without issue as it will be writing according to the best practices. Let us connect to get started now.
$140 AUD 1 päivässä
5,0 (2 arvostelua)
2,4
2,4
Käyttäjän avatar
Hi I am expert in google apps script and its sheet automation. I have gone through your requirements and confident of completing it as per that. I have already many projects in GAS so this will also be easy for me Thanks
$100 AUD 7 päivässä
5,0 (1 arvostelu)
1,0
1,0
Käyttäjän avatar
Hi, I, Denys Yuryev, am prepared to develop a Google Apps Script (GAS) macro to automate the merging and synchronization of data from two independent customer databases in Google Sheets, as outlined in your project. My approach will involve: Understanding the structure and unique identifiers of both customer databases to ensure seamless data merging. Creating a reliable macro that merges and compares data based on specified criteria, highlighting potential duplicates for manual review. Providing thorough documentation and instructions for users to ensure easy utilization and support of the macro. With my experience in Google Sheets and Google Apps Script development, I am confident in delivering a high-quality solution that meets your requirements effectively and accurately. I look forward to the opportunity to discuss this project in more detail. Best regards, Denys Yuryev
$150 AUD 7 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
Drawing from my extensive experience as a full-stack developer with a particular focus on Google Apps Script and Google Sheets, I believe I am the perfect fit for your Google Apps Script Macro project. Having spent years proficiently working within projects requiring backend and frontend integration, I am well-versed in data manipulation techniques and scripting logic—skills that would be invaluable to successfully merging and comparing data from your two customer databases. What sets me apart is not just my technical expertise, but my meticulousness and attention to detail. These attributes are necessary when dealing with large amounts of data, avoiding calculation errors, and ensuring that all fields (including names, email addresses, phone numbers) are merged flawlessly without duplicity. Additionally, I will take great care in creating comprehensive documentation that will serve as an easy-to-understand guide for future use. In previous projects akin to yours, I've worked both quickly and efficiently without compromising the quality of work produced. My goal is to complete this project in a timely manner while delivering a macro script that fulfills all your requirements—automating merging/syncing and accurately detecting potential duplicate entries—for a smooth and efficient experience thereafter. Let's discuss further about your specific project requirements so we can align our goals better.
$140 AUD 7 päivässä
0,0 (0 arvostelua)
0,0
0,0

Tietoja asiakkaasta

Maan AUSTRALIA lippu
Northcote, Australia
4,8
128
Maksutapa vahvistettu
Liittynyt heinäk. 7, 2011

Asiakkaan vahvistus

Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.