Google Apps Script Macro Dev
Budget: $30 – $250 AUD
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.
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.