Upwork home
Sign Up
Secondary
Gaurav J.

Gaurav J.

Bengaluru, India
Job Success
Top Rated Plus

Google Sheets | Google Apps Script | Zapier | Make (Integromat) Expert

An integrations expert, able to use tools such as Zapier, Make (Integromat) and Microsoft Power Automate 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 GOOGLE APPS SCRIPT - INTEGRATION WITH API: Authentication - simple API key parameter Basic authentication OAuth2 Retrieving data via the GET calls from APIs. Performing paginated calls to retrieve very long lists of results in separate calls. Updating data via POST/PUT/DELETE calls. - Acuity Scheduling: Create Appointment in Acuity, Get New Appointment, Get Cancelled Appointment - Clio: Getting Matters, Activities, and Bills - Nexmo: Send SMS - 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. Have built custom javascript code steps, webhooks, Zaps with 25+ steps - 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 - Xero: Create new Sales Invoice and Purchase Order - 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 - FTP: Read files from FTP - CSV: Read CSV files and get line items - APIs: Call custom APIs and read the response
Mar 11, 2022 - Mar 29, 2023

No feedback given

Private earnings
Rating is 5 out of 5.
5.00 Mar 14, 2023 - Mar 19, 2023
Private earnings
Rating is 5 out of 5.
5.00 Mar 1, 2023 - Mar 2, 2023

"Excellent work! Gaurav was easily + quickly able to help set up a custom API trigger within Zapier for one of our clients. Just what I needed! Would recommend if you're looking for a Zapier expert. Thanks Gaurav!"

Private earnings
Rating is 5 out of 5.
5.00 Feb 25, 2023

"I spended hours for the fix this guy did it over in one minute -- he is expert!!"

Private earnings
Nov 29, 2022 - Feb 24, 2023

No feedback given

Private earnings
Dec 14, 2022 - Jan 30, 2023

No feedback given

Private earnings
Rating is 5 out of 5.
5.00 Nov 14, 2022 - Dec 28, 2022

"This freelancer had a good disposition and lots of patience with my questions and parameters for the project, he completed it on time and budget and was cooperative and understanding"

Private earnings
Dec 8, 2022 - Dec 25, 2022

No feedback given

Private earnings
Rating is 5 out of 5.
5.00 Oct 31, 2022 - Nov 2, 2022
Private earnings
Jul 29, 2022 - Oct 28, 2022

No feedback given

Private earnings
Gaurav J. has more jobs. Create an account to review them

Portfolio

This project involved tracking the new files in Google Drive and upload these files to Hubspot deals and contacts using Hubspot API.
Uploading files from Google Drive to Hubspot deals and contacts
Generating the schedule for team members for various activities considering they don't work on same activity every week.
Generating Team Schedule for several weeks
Want to see more? Create Account

Skills

Gaurav J.

Gaurav J.

Bengaluru, India
Job Success
Top Rated Plus
603
Total Jobs
5,330
Total Hours

Google Sheets | Google Apps Script | Zapier | Make (Integromat) Expert

Specializes in
An integrations expert, able to use tools such as Zapier, Make (Integromat) and Microsoft Power Automate 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 GOOGLE APPS SCRIPT - INTEGRATION WITH API: Authentication - simple API key parameter Basic authentication OAuth2 Retrieving data via the GET calls from APIs. Performing paginated calls to retrieve very long lists of results in separate calls. Updating data via POST/PUT/DELETE calls. - Acuity Scheduling: Create Appointment in Acuity, Get New Appointment, Get Cancelled Appointment - Clio: Getting Matters, Activities, and Bills - Nexmo: Send SMS - 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. Have built custom javascript code steps, webhooks, Zaps with 25+ steps - 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 - Xero: Create new Sales Invoice and Purchase Order - 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 - FTP: Read files from FTP - CSV: Read CSV files and get line items - APIs: Call custom APIs and read the response
Mar 11, 2022 - Mar 29, 2023

No feedback given

Private earnings
Rating is 5 out of 5.
5.00 Mar 14, 2023 - Mar 19, 2023
Private earnings
Rating is 5 out of 5.
5.00 Mar 1, 2023 - Mar 2, 2023

"Excellent work! Gaurav was easily + quickly able to help set up a custom API trigger within Zapier for one of our clients. Just what I needed! Would recommend if you're looking for a Zapier expert. Thanks Gaurav!"

Private earnings
Rating is 5 out of 5.
5.00 Feb 25, 2023

"I spended hours for the fix this guy did it over in one minute -- he is expert!!"

Private earnings
Nov 29, 2022 - Feb 24, 2023

No feedback given

Private earnings
Dec 14, 2022 - Jan 30, 2023

No feedback given

Private earnings
Rating is 5 out of 5.
5.00 Nov 14, 2022 - Dec 28, 2022

"This freelancer had a good disposition and lots of patience with my questions and parameters for the project, he completed it on time and budget and was cooperative and understanding"

Private earnings
Dec 8, 2022 - Dec 25, 2022

No feedback given

Private earnings
Rating is 5 out of 5.
5.00 Oct 31, 2022 - Nov 2, 2022
Private earnings
Jul 29, 2022 - Oct 28, 2022

No feedback given

Private earnings
Gaurav J. has more jobs. Create an account to review them

Portfolio

This project involved tracking the new files in Google Drive and upload these files to Hubspot deals and contacts using Hubspot API.
Uploading files from Google Drive to Hubspot deals and contacts
Generating the schedule for team members for various activities considering they don't work on same activity every week.
Generating Team Schedule for several weeks
Want to see more? Create Account

Skills

As Needed - Open to Offers

< 24 hrs response time

Browse similar freelancers

Sign up to discuss your project with Gaurav J.