Freelancers using Apps Script in Buenos Aires

Freelancers using Apps Script in Buenos AiresFreelancers using Apps Script in Buenos Aires

Projects People

Buenos Aires, Argentina

Business Systems Architect | Roadmap & GSheets & Automation

5.0: Rating

1: Followers

Business Systems Architect | Roadmap & GSheets & Automation

Cover image for Apps Script to create Google

Apps Script to create Google events and tasks when a cell is updated. The requirement was to automatically create Google Tasks and Calendar events when a task is entered in Google Sheets. • Implemented automatic updates to Google Tasks when the task name, status, or date is modified in the sheet. • When a task is completed in Google Tasks, its status updates automatically in the spreadsheet for all assigned users. • Meetings are scheduled via the sheet, generating Google Calendar events for all Gmail participants listed in the cell. • Added automatic updates to calendar events when changes are made in the sheet. • Entire solution built using Google Apps Script.

1

18

Cover image for My proprietary system for managing

My proprietary system for managing and achieving any goal you set

1

4

187

Cover image for The client’s goal was to

The client’s goal was to enter a new international market with a defined value proposition — but lacked clarity on the required steps. I conducted a focused strategy session with the business owner, structured the full market entry strategy into clear blocks, and mapped every step into my proprietary task management system. I defined timelines, estimated budgets, assigned responsibilities, and outlined the necessary org structure to execute the plan. The client received a complete roadmap, including a mind map in xmind and pdf formats, along with a fully structured Google Sheets action plan.

1

17

Cover image for Profit and loss tracker for

Profit and loss tracker for daily financial indicators +KPI dashboards. I developed a spreadsheet with an advanced system for tracking daily P&L metrics. The sheet allows analysis across different time frames (week, month, 6 months, year) and includes dynamic projections based on the last 3, 5, or 7 days of performance. It features: – Automatically calculates planned targets and actual results using built-in formulas. – Assigns responsible owners and priorities to each metric. – Manager evaluation system that links daily performance ratings to employee compensation. – KPI dashboards for clear visualization.

1

22

Buenos Aires, Argentina

Google Sheets, Apps Script and Looker Studio expert

Google Sheets, Apps Script and Looker Studio expert

Cover image for I built a fully automated

I built a fully automated booking system using Google Sheets and Apps Script that: • Allows clients to select their preferred date and time • Automatically blocks unavailable slots based on Google Calendar • Syncs events instantly with the owner’s calendar • Sends automatic confirmation emails • Lets clients view their booking status, leave updates, or cancel directly from email Each appointment is automatically recorded in Google Sheets with a unique ID, client details, and message history, creating a structured and trackable database. It also includes a built-in analytics dashboard with real-time metrics such as: • Total appointments • Cancellation rate • Peak booking demand • A heatmap, showing weekly booking distribution Interface, logic, booking rules, and language are fully customizable based on each client’s needs. 😸

2

3

162

Cover image for Logistics Dashboard

Logistics Dashboard

1

4

Cover image for Employee Attrition and Performance Dashboard

Employee Attrition and Performance Dashboard

1

1

Cover image for Automated Marketing Dashboard for PPC Performance.

Automated Marketing Dashboard for PPC Performance.

1

1