Explorar las categorías
Explora
Fiverr Pro
Español
$
USD
I will automate google sheets with apps script, dashboards and API integration
Data Analyst for Excel VBA, Apps Script, Power BI and SQL Automation
Hi, I'm Sourab, a Data Analyst and Excel VBA developer with 10+ years of experience and 500+ automation projects delivered.
I build Excel VBA macros and userforms, Google Sheets Apps Script automatio...
Nivel 2
Ha cumplido con los criterios de alto rendimiento y tiene un historial comprobado de cumplimiento de las expectativas de los clientes.
Acerca de este Servicio
Your Google Sheet already holds the data. It just doesn't do anything with it yet.
I write Google Apps Script that turns a spreadsheet into a working system, so the copying, chasing and re-formatting stops happening by hand.
WHAT I BUILD
- Automations that fire on edit, on form submit, on a button, or on a schedule
- Multi-sheet and multi-file syncing, de-duping and data cleaning
- Automated emails, PDF exports and Google Docs generated from your rows
- Live dashboards that refresh themselves
- Connections to outside tools through their API: CRM, invoicing, inventory, Slack, Airtable
- Custom menus, sidebars and small web apps so your team never touches the code
HOW IT WORKS
Send me the sheet (a copy with dummy data is fine) and tell me what should happen. I confirm the scope and a fixed price before you order. You get commented source code, a short written guide, and a walkthrough video on request.
Not sure which package fits? Message me first. I will tell you honestly whether your job is a 45 dollar fix or a 300 dollar build.
Plataforma:
Excel
•
Hojas de cálculo de Google
Tecnología de desarrollo:
vba
•
google apps script
Experiencia:
Fórmulas
•
Funciones
•
Macros
•
Tablero
•
Gráficos
Mi porfolio
FAQ
Will you need access to my real data?
No. A copy of the sheet with dummy or anonymised rows is enough to build and test. If you do share live data, I only ask for the access level the script actually needs, and it is removed on delivery.
Do I get the code, or is it locked?
You get the full commented source code in every package, plus a short guide explaining what each function does. Nothing is hidden and you are never tied to me.
What if my sheet changes later?
Small structural changes are usually covered by your revisions. Beyond that, the 30-day support extra or a monthly retainer keeps it maintained. Message me and I will quote it plainly.
Can you connect my sheet to another app?
Usually yes, if the app has an API or a webhook. Tell me the tool and I will confirm before you order. API work sits in the Standard and Premium packages.
How fast can you start?
I reply within a few hours and most jobs start same day. Rush delivery is available as a gig extra if you have a deadline.
Which package do I need?
Message me with a screenshot of your sheet and what you want to happen. I will point you at the right package, including the cheaper one if that is genuinely all you need.
Should I message you before ordering?
Yes, if you can. A screenshot of your sheet and a sentence about what should happen is enough for me to confirm the package and timeline, and to tell you early if something is not possible in Apps Script.
Can you build a dashboard in Google Sheets?
Yes. Summary tabs with charts, filters and auto-refresh from your raw data are a common order. If you need Looker Studio on top of the sheet, that is quoted separately.
Will the script keep running without you?
Yes. Scripts run on your Google account with time-based or edit triggers, so nothing depends on my machine. I set the triggers up and show you where they live.
Can the sheet send emails or notifications?
Yes. Gmail emails, calendar events, Google Chat or Slack messages and PDF reports can all be sent automatically from the sheet. Tell me the trigger and who should receive it.
