📊 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)