I seek to automate data collected from a google form (To fine tune logic accordingly) to google sheets, and also to move column cell values from primary sheet to secondary sheet by logic.
The secondary sheet to host the calculations to automatically calculate for quotation and invoicing and other workflow documentation
The quotation and invoice will automatically be sent to customers via email
Skills
Proficiency in advanced formulas (e.g., VLOOKUP, ARRAYFORMULA, IMPORTRANGE) and automation tools (e.g., Apps Script, Zapier integration)
Experience in data analysis, dashboard creation, and workflow optimization
Knowledge of integrating Google Sheets with other tools (e.g., APIs, databases)