Drop-down menu to authorize permission of google apps script. Create a fixed number of copies of active spreadsheet and place them in a particular folder in Google Drive.
Every time a user fills the form, automatically fill out Google Document template, generate PDF and send an email to the user.
Using Google Cloud NLP for sentiment analysis of survey responses.
Working GUI of Action Tracker with buttons and graphics.
Supplier Management System for suppliers and customers to track and automate the process of products supply. A list of SUPPLIERS & CUSTOMERS > Get LEADS from CUSTOMERS > SUPPLIERS BID on those LEADS > Select a BID based on some criteria > Make OFFER to CUSTOMERS > CUSTOMER accept the OFFER and place an ORDER.
For every incoming email, compares the body of email with past emails in a particular label. If the email body is a duplicate, moves the new email to a separate label.
Automatically send customized emails from data in Google Sheets. The added functionality includes sending a different customized email for different sheets in the spreadsheet.
Archive data for every column in the main sheet to multiple sheets with the respective column name. The data is archived every day.
Automatically create customized documents from data in Google Sheets. The added functionality includes creating different formats for different documents.
Deployed as a Web App, Delete all files and folder from Google Drive at the click of a button.
Automatically send customized SMS from data in Google Sheet using 46elks API.
Filters emails from PPH and get job links from the PPH recommendations, clean those links and save thems in a google sheet.
Imports events from google calendar between specific data and having specific word, one row per guest. For same guest, divides the first and second meetings in to two separate sheets.
Convert user-selected slides into images, save them a drive folder. Then log time of creation, text from notes section and image file link to a spreadsheet.
Delete notes from all slides in a presentation.
Takes data from google sheet including Campaign List, Campaign Title, Campaign Subject, Campaign Preview, Template, List, Button Links, Image Links. Then using this data creates, updates and sends one campaign per row.
Provides click analysis for various campaigns on one sheet with campaign id, campaign name, first name, last name, time of click.
An independantly hosted HTML Form, to upload files to Google Drive and save responses + file url to Google Sheets.
Automatically generate multipage invoice from data in Google Spreadsheet by choosing client, time period and invoice number.
Populate GSheet with list of people viewing particular videos in Google Drive using Reports API.
Custom HTML form as a Google Web App with phone verification using Twilio API.
Send Message on whatsapp using Twilio API.
Triggers a reminder by call to a user to leave for this meeting 10 mins before the meeting time using Twilio and Google Apps Script.
Automatically adds members from Google Sheets list to Google Group every time GSheet is edited with new members emails.
Boilerplate code to create Google Data Studio connector for Airtable. Lets you enter api key, base and table name to fetch the relevant data.
DISCLAIMER: SOME PART OF THE SCRIPTS MIGHT BE TAKEN FROM OTHER SOURCES AND EDITTED ACCORDING TO MY NEEDS. NO COPYRIGHTS INFRINGEMENT INTENTED.