Banner Image

All Services

Programming & Development

Google Script

$5/hr Starting at $25

Expert level Google Spreadsheets user. Two years experience designing sheet based tools and systems, one plus year experience incorporating complex Google Scripts to allow for more sophisticated features. Google Spreadsheets and Scripts experience: 1) Automatic Mail Merge: Created a Mail Merge system tailored to the specific needs of my former company - designed to dynamically populate and automatically deploy hundreds of template based emails at once, attaching files from standardized Google Drive folder paths as needed, automatically updating a Status tracker, intuitively building HTML for more complex email structures, and preventing errors by recognizing and documenting predicted problems. 2) Client Index: Assembled an index of all client data in a single location by combining standardization mechanisms and programmatically ascertained fields. This index was imported into the background of every subsequent sheet used by the company to allow for rapid, accurate, and seamless data integration. 3) Client Status Document: Developed the governing procedural document for the company. Through a combination of data validation, complex spreadsheet functions, and Google's built-in Scripting service, the document was able to easily incorporate any pertinent client data into the process, generate timestamps on status changes to track efficiency and allow for the use of formatting based warnings for inefficiency, and display sophisticated procedural statistics.

About

$5/hr Ongoing

Download Resume

Expert level Google Spreadsheets user. Two years experience designing sheet based tools and systems, one plus year experience incorporating complex Google Scripts to allow for more sophisticated features. Google Spreadsheets and Scripts experience: 1) Automatic Mail Merge: Created a Mail Merge system tailored to the specific needs of my former company - designed to dynamically populate and automatically deploy hundreds of template based emails at once, attaching files from standardized Google Drive folder paths as needed, automatically updating a Status tracker, intuitively building HTML for more complex email structures, and preventing errors by recognizing and documenting predicted problems. 2) Client Index: Assembled an index of all client data in a single location by combining standardization mechanisms and programmatically ascertained fields. This index was imported into the background of every subsequent sheet used by the company to allow for rapid, accurate, and seamless data integration. 3) Client Status Document: Developed the governing procedural document for the company. Through a combination of data validation, complex spreadsheet functions, and Google's built-in Scripting service, the document was able to easily incorporate any pertinent client data into the process, generate timestamps on status changes to track efficiency and allow for the use of formatting based warnings for inefficiency, and display sophisticated procedural statistics.

Skills & Expertise

BackgroundsData ManagementDesignDisplaysEmail ServicesFolder DesignGoogleHTMLLayout DesignMailSpreadsheetsSystems EngineeringTemplatesTooling Design

0 Reviews

This Freelancer has not received any feedback.