Google Sheets & Apps Script Developer

madsheets builds solutions for the google workspace. We design and implement systems and MVPs in google workspace for small to medium sized businesses all across North America and the world.

We are currently looking for a google sheet developer.

The ideal candidate would have the following skills:

Google Sheet development

Experience with all popular formulas (VLOOKUPS, INDEX, MATCH, FILTER, QUERY, SUMIFS/COUNTIFS, ARRAYFORMULA etc.)

Experience with Named Ranges, Conditional formatting and data validation

Experience with creating dashboards (formatting a spreadsheet and adding charts etc.)

Google Apps Script development

Experience with all major google apps script classes (DriveApp, SpreadsheetApp, CalendarApp, SessionApp, GmaillApp, FormApp etc.)

Experience with simple and installed triggers (onFormSubmit, onEdit, onOpen etc.)

Experience with JavaScript

Experience with HTML

Experience with CSS

Following skills will greatly distinguish you from other applicants:

Experience with with google apps script based webapps (doGet, doPost)

API integration between google sheets and third part applications such as WordPress, Shopify, CompanyCam, Jotforms etc.

Build webhook receivers using google apps script

AppSheet

Preferred soft skills

Good spoken and written English

Great ability and eagerness to learn

Job Type: Full-time

Pay: Rs100,000.00 - Rs120,000.00 per month

Work Location: In person