I will design google sheet and integrate with API

GOOGLE SHEETS & OTHER GSUITE SERVICES:

- Sheets: 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: create custom forms for different recipients via script

- Docs: fill a template with Sheets data and convert to PDF/Word document/CSV

- API Integration - Calling the APIs and passing data from Google Sheet to API

OTHER APPS SCRIPT(GAS) PROJECTS:

- Webhooks: Send webhooks with sheets data (to Zapier & Integromat)

- Sheets Add-ons: Add-on to compare the data between Sheets and to send the Emails

INTEGRATION VIA REST APIs IN APPS SCRIPT:

Very proficient. Authentication using simple API key parameter, Basic authentication, OAuth, OAuth2.

- Acuity Scheduling, Nexmo, Hubspot, Infusionsoft, MailChimp, Pipedrive, Shopify, Trello, Typeform, 46Elks, Bitly, Bright Pearl, QuickBooks