Tooba A.

An integrations expert, able to use tools such as Zapier, Make.com and Bubble.io to create integrations between many different applications. I have excellent skills in Google Apps Script and Google Sheets, and reporting tools such as Google Data Studio. GOOGLE SHEETS and GSUITE: - Sheets: Designing complex dashboards & reporting; field lookups, query & format conversions - Drive: Reading folders and files & list them in Google Sheet for processing - Forms: Create custom forms for different recipients via Google Apps Script - Docs: fill a template with Google Sheets data and convert to PDF/Word document/CSV - Calendar: Create and sync calendar events with data from Google Sheets - Gmail: send emails, read emails; format & forward emails; designing custom email tracking systems; processing attachments and send them to APIs - API Integration - Calling the APIs; passing data from Google Sheet to API; populating data into Google Sheet from API - Acuity Scheduling: Create Appointment in Acuity, Get New Appointment, Get Cancelled Appointment - Clio: Getting Matters, Activities, and Bills - ClickUp: Manage Team and Tasks - Hubspot: Retrieve contacts from lists, uploading the documents to deals and contacts - MailChimp: Retrieve all existing subscribers, retrieve campaigns report - Pipedrive: Get the list of activities - Shopify: Get product names & details; create and delete meta fields. - Trello: Create new card; add attachments to existing card - Xero: Update invoice data in Google Sheets (send & receive) - 46Elks: Send SMS and receive the responses - Bitly: Shortening the URLs - Bright Pearl: Search Product and read Custom field value - QuickBooks: Getting the Reports data - Billbee: Get Products and Orders ZAPIER: I have created Zapier Apps using CLI as well as Builder. - Acuity Scheduling: Getting the new appointments, rescheduled appointments and canceled appointments into Google Sheets - Calendly: Getting new and canceled events information - Gmail: Send emails; build a parser - Google Drive: Upload and read files - Google Sheets: Send data as a new row; search and retrieve data - HubSpot: Create Contact and deal - Active Campaign - Add Subscribers - Pipedrive: Create new contacts, activities, and deals - CallRail: Getting new SMS and calls - QuickBooks: Create Sales Receipts - MailChimp: Create and Update Contacts - Shopify: Get new Orders - BigCommerce: Get new Orders - Trello: Create new Cards - Clio: Create new contacts and matters - ClickUp: Manage Team and Tasks - Clickfunnels: Get new form submissions - Facebook Ads Lead: Get new Leads - Calling APIs(Acuity Scheduling API, Drchrono and Virtuous API) through custom code Make (Integromat): Have built complex Scenarios using Router, Iterator, and Aggregator. - Hubspot: Create deal and contact - Woocommerce: Getting and creating Order - Shopify: Getting Orders and Customers, Updating Fulfillment details - Quickbooks - Create invoice, customer, and quote - Xero: Create a new invoice - Trello: Create new Card - Zoho: Create new Contact and Client - Google Drive: Read files from Google Drive - ClickUp: Manage Team and Tasks - CSV: Read CSV files and get line items - APIs: Call custom APIs and read the response