sebastienc23

Google scripts, zapier or IFTTT enables companies to automate, connect with an infinite number of possibilities. Mastering them is my passion.

GOOGLE SHEETS & OTHER GOOGLE SERVICES:

For 2 years I've helped companies make better use of all Google can offer.

- 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 VIA REST APIs IN GOOGLE APPS SCRIPT:

Very proficient. Authentication using simple API key parameter, Basic authentication, OAuth, OAuth2. Retrieving data via GET calls from APIs in json, XML or csv format. Performing paginated calls to retrieve very long lists of results in separate calls. Sending/updating data via POST/PUT/DELETE calls.

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

ZAPIER:

Very advanced user. Have built custom javascript code steps, webhooks, zaps with 10+ steps and linked zaps that connect between each other to execute different tasks according to the result of a specific step in a master zap.

- Gmail: Send emails to employees requesting actions from CRM updates
- Google Drive: Upload email attachments
- Google Sheets: Send parameters to sheet and get calculated results back
- HubSpot: Send users a personalised text on Twilio based on Google Sheets lookups
- Pipedrive: Automate workflows to send emails & update stats when deals change stage
- Quickbooks: Create draft
- Smartsheet: Trigger on row update and filter by field value to create an invoice in
- Typeform: Automate response collection into Pipedrive notes
- Xero: Create new draft payments