📊 Interactive dynamic dashboards for Data Analysis in Excel, Google sheets.
👉🏻 Google Add-ons
👉🏻 Integration of 3rd party API
👉🏻 Creation custom functions for Google sheets
👉🏻 Excel / Google sheet based custom forms.
👉🏻 Excel / Google Sheets custom formulas.
👉🏻 Scraping content from the web into your local Excel / Google sheets.
👉🏻 Development Google Apps scripts for optimization and automation of business processes (e.g. Generate hundreds of pdf invoices per month for your clients)
👉🏻 Automation of data cleaning and transformation.
Programming languages:
👉🏻 VBA, Google apps script, javascript, PHP, SQL
AUTOMATION IN GOOGLE APPS SCRIPT:
👉🏻 Sheets: very complex dashboards & reporting; field mapping, lookups & format conversions
👉🏻 Drive: list & modify permissions of all files in Drive; copy folder and its contents in bulk
👉🏻 Forms: expense tracking system, create custom forms for different recipients via script
👉🏻 Docs: fill a template with Google Sheets data and convert to PDF
👉🏻 Calendar: Read calendar events and list them in Google Sheets
👉🏻 Calendar API (for advanced operations): Add Google Drive attachments to calendar events
👉🏻 Gmail: send emails with sheet data; format & forward emails; update reports with data in csv attachments
👉🏻 Gmail API (for advanced/business-wide operations): update signatures in bulk
👉🏻 Directory API: update user information for users in the company directory
👉🏻 Contacts: Match sheet email addresses to existing contacts and retrieve other details
INTEGRATION IN GOOGLE APPS SCRIPT:
👉🏻 Airtable: Backup tables to Google Sheets; Create/delete rows automatically
👉🏻 Bullhorn: Get new contacts
👉🏻 Flexitime: Lookup 'Work' items and their cost
👉🏻 Hubspot: Retrieve contacts from lists
👉🏻 Infusionsoft: Retrieve order details as line items
👉🏻 MailChimp: Retrieve all existing subscribers
👉🏻 Pipedrive: Get list of activities
👉🏻 Reply.io: Create new contacts
👉🏻 Shopify: Get product names & details; get list of all orders; get UTM details using ShopifyQL
👉🏻 Trello: Create new card; add attachments to existing card
👉🏻 Typeform: List all form responses in a sheet
👉🏻 Upwork: Fetch all hours paid to freelancers in a specific week
👉🏻 WorkflowMax: 2-way sync jobs with Google Calendar events
👉🏻 Xero: Update invoice data in Google Sheets (send & receive)