You will get anything with google sheet and google apps script / ads script
Project details
I have built dozens of Google Apps Scripts for a variety of Automation tasks in Google Sheets. Docs, Slides, Calendars, Gmail and Drive . Projects I have delivered to my clients also included "making use of Google sheets and drive as a database".
Programming Languages
JavaScriptCoding Expertise
Cross Browser & Device Compatibility, Performance Optimization, DesignWhat's included
| Service Tiers |
Starter
$25
|
Standard
$50
|
Advanced
$75
|
|---|---|---|---|
| Delivery Time | 1 day | 1 day | 1 day |
Number of Revisions | 1 | 2 | 3 |
Number of Pages | 1 | 2 | 3 |
Design Customization | - | ||
Content Upload | |||
Responsive Design | - | - | |
Source Code |
About Ali
Google Apps Script, Google Sheets and integrations expert
Cayirova, Turkey - 10:53 pm local time
Get things done quickly and easily by creating automation between Google apps script and your other applications.
I can do the following:
- Google sheets or any Gsuite product automation
- 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 it 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
- Google apps script API
- Google apps script forms
- Google apps script documentation
- Google apps script send email
- Google apps script console
INTEGRATION VIA REST APIs IN GOOGLE APPS SCRIPT:
Very proficient. Authentication using simple API key parameter, Basic authentication, OAuth, OAuth2. Retrieving data via getting 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 the list of activities
- Reply.io: Create new contacts
- Shopify: Get product names & details; get a list of all orders; get UTM details using ShopifyQL
- Trello: Create a new card; add attachments to the 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)
"Ali is a fantastic developer - very easy to communicate with, fast, experienced, understands the task well, and does it exactly as expected. I'd love to work with him again. Highly recommended!"
👌My strongest sides:👌
✔️ Targeting on success in clients projects
✔️ Quality & fast communication
✔️ Deep diving into clients tasks
✔️ Work in one team with my client
✔️ Years of programming experiences in different directions
✔️ Persistence and curiosity
✔️ Desire to grow up skills
✔️ Deep learning new technologies
✔️ Optimistic view on life :)
If it sounds interesting to automate things and get quick results, send me a message and we'll schedule a time to talk.
Steps for completing your project
After purchasing the project, send requirements so Ali can start the project.
Delivery time starts when Ali receives requirements from you.
Ali works on your project following the steps below.
Revisions may occur after the delivery date.
1. Gathering Client's Requirements
In the first I try to talk to my clients and understand his/ her requirements.
Analyzing the Requirements
After gathering information related to the requirements, I analyze this information to find whether the requirements are even possible to achieve or not. I then provide my feedback to the client/ s.