Templates by The Vlookup

HR Analytics Dashboard

Team Wise, employee details

HR Sheets Analytics

A google Sheet that gives you a detailed overview of the employees, department wise, where you can track, salary leaves, score and other relevant details of your team members with an easy to use Google Spreadsheet. This can scale as your team scales, with option to add more Teams and more team members.

https://docs.google.com/spreadsheets/d/1ulI4nV7TKxUjDxuCuj5txID6k21A1Lju15IwximG8aE/copy

Create a Google Doc and convert it to PDF using Google Apps Script

Google Sheet to PDF

Via Google Doc Template

PDF Sheets Template

With this system, you can generate different types of PDFs by creating template in Google Docs and having Data in Google Sheets. It is very easy to use. If you want further personalization, you can contact us to hire Google Sheet Experts

https://docs.google.com/spreadsheets/d/1Ui4pUeOCpvUotk-DEwyw_hUBmQamUGGyH-2oadY7T0M/copy

https://www.youtube.com/watch?v=ZUOBQ0sQUgw&ab_channel=IdeaRise

Create ID Card for Students using Google Sheet

ID Card Template

Using Google Sheet Data

I Card Sheets Template

If you have a list of student's data, you can create Identity Card for each student using this template. You can also modify the structure to create report cards or any other document of students. If you feel you have a complex requirement, you can hire Google Sheet Expert to get your work done.

https://docs.google.com/spreadsheets/d/1Iw3NHZ7jmxAE8noOVP83zgA-3y9IZUQIKYSmkJ5QJQo/copy

https://www.youtube.com/watch?v=lmWb_cl97S8&ab_channel=IdeaRise

Image to Text

Using Google Apps Script

OCR Image-Text Script

This Template is an example of OCR feature where you can upload an image and extract the data

https://docs.google.com/spreadsheets/d/1oXFNTaqAImwCy0eW0mO9u_M7JNXlEtfYlO64WatDFOk/copy

https://www.youtube.com/watch?v=yZFm7XxHLdw&ab_channel=IdeaRise

Design an amazing Sales Dashbaord in Google Sheet

Sales Dashboard

With Charts & Graphs

Sales Sheet Graphs

Have bird eye view of your sales trend by looking at important numbers and graphs. You can customize it as per your need and add more numbers and trends. You can also hire a Google Sheet Expert to make it best for your need.

https://docs.google.com/spreadsheets/d/1HowGyr9vh42TU7eST8fx8Ju0mX_L9_HvED1Cj1nZUn8/copy

Create a deal in Pipedrive on google form submission

Google form to Pipedrive

Create a new Deal

Form Pipedrive Integration

In this system, a google form can be hosted on a website or any other place. Whenever a user fills up the form, a new deal gets created in Pipedrive. The message entered by user, becomes notes in the deal. If you have complicated set up, you can hire a Google Sheet and Apps Script developer from our website.

https://docs.google.com/spreadsheets/d/1mk5u0qikhCeSuaux_Js0f5HJfvR64WW_6dneSFRvJIc/copy

https://www.youtube.com/watch?v=mIIPebnx0PE

Google form to Hubspot

Create a new Deal

Form Hubspot Integration

In this system, a google form can be hosted on a website or any other place. Whenever a user fills up the form, a new contact and deal gets created in Hubspot. The message entered by user, becomes notes in the deal. If you have complicated set up, you can hire a Google Sheet and Apps Script developer from our website to set up Hubspot Integration.

https://docs.google.com/spreadsheets/d/1NTsSXYEhpLzhYsg3C3c6NaJBiBGLL6vJtWxASyi2NDY/copy

https://www.youtube.com/watch?v=_I1s3yy5x6Y

Trello Data to Sheet

Boards and Cards

Trello API Integration

This is a useful template to fetch Trello data to your Google Sheet. You only need to add the Trello API token and key and template would be ready to use.

https://docs.google.com/spreadsheets/d/1qXJoG6zkvGlrB0sJV77bsoOMny-FEQr_sAd5ybX1P1k/copy

https://www.youtube.com/watch?v=EG5Rg9l0phg

Get Google Contacts Data to a Google Sheet

Contacts to Sheet

All Details

Contact Sheet Google

Using this template, you can fetch all your contact data from Google Contacts to Google Sheet. You can use this to manage your contacts easily.

https://docs.google.com/spreadsheets/d/1-XbQK4VSCLaHqr0IbHooxLB8KToXUbQSgJLj6ZXrvds/copy

https://www.youtube.com/watch?v=SuGJi84012c

Custom Form

Data saved to Sheets

Form Custom Apps Script

Google form has many limitations, where we can not design it as per our need. One of the biggest issue we face is to have dependent dropdown. This template solves that by having a custom form created using Google Apps Script, where you can have dependent dropdowns and complete desigbn of the form can be customized. For more complex requirement, feel free to hire a Google Sheet Developer.

https://docs.google.com/spreadsheets/d/1r_XXC4Oh-yNrOOdEHSHePSiSQQkZvueu1np5DH9lO3E/copy

https://www.youtube.com/watch?v=iKFwFbRuvzQ

Meal Planner

Customized Calorie Value

Meal Planner Sheet

This template is for Fitness Professionals, where you can add different source of Carb, Proteins and fats. Depending on the metabolism rate and other factors, it calculates the plan. The final plan also gets emailed very easily.

https://docs.google.com/spreadsheets/d/1xJ_Zd0_J7juwj7w0O30XxDsgHkX0wXcrD3GUjRNP_ds/copy

https://www.youtube.com/watch?v=Xj32SLKB-ds

Get Events from Google Calendar to a Google Sheet

G Calendar to Sheet

In One Click

Calendar Sheets Events

If you have too many events in your Google Calendar, you can fetch them, filtered by date and Calendar ID, to a Google sheet, using this Template. It gives you all the details about each events like Date, Time, Description, Location etc.

https://docs.google.com/spreadsheets/d/1P0NIPh3GoyxbamhQx4BIAccScTbkPNcQLV-3BehNfh0/copy

https://www.youtube.com/watch?v=NoghFGzvJBw

Fetch emails in Gmail Inbox to Google Sheet

Gmail to Sheet

With Attachments too

Gmail Sheets Attachments

This template is designed to fetch Gmail Imbox data like subject, date, from, to, body, attachments etc. to Google Sheets. It saves all Attachments in a defined Google Folder.

https://docs.google.com/spreadsheets/d/1evMvbt5OA1Oi-UUNplp-rAg7AMT8di4015z2HkDYUcI/copy

https://www.youtube.com/watch?v=OBT-FMb4eTU

Get list of files and folders in Dropbox to Google Sheet

Dropbox Data to Sheet

List of Files & Folders

Dropbox Sheets Apps Script

Get List of Files and Folders in your Dropbox to a Google Sheet. Get API Credentials from Dropbox, paste in the credentials tab. In one click, you have all your files and folders listed in a clean format.

https://docs.google.com/spreadsheets/d/1mJml96GocmKwhCNq27vDioAqWekHZ4eCchXfmt5Wf8o/copy

https://www.youtube.com/watch?v=s2wef7NIM9E

Get All Files and Folders details from Google Drive to a Google Sheet

Google Drive to Sheet

List of Files & Folders

G Drive Sheets Apps Script

Get List of Files and Folders in your Google Drive to a Google Sheet. No Limit on number of files and folders. Start fetching data from where the script left.

https://docs.google.com/spreadsheets/d/1l64bGYRtkhbpXPUu4f_cbHhN-P5yWO9XGW-P3a74Sew/copy

https://www.youtube.com/watch?v=W26cPE-ADBA

Form to Mailchimp

Add Subscribers Automatically

Mailchimp Sheets Subscribers

If you want to grow your audience, this is a very easy and smooth flow. You have a Google Form, that collects information from your audience. That information is stored in Google Sheet and automatically added to a selected Audience in Mailchimp.

https://docs.google.com/spreadsheets/d/1DZO_9TRDA6JSu2eJbfiQbw1UEHAy1Kp__bBhDl4PRyk/copy

https://www.youtube.com/watch?v=SDYicC2qls4

Fetch Data from AirTable to Google Sheets

Airtable to Sheet

Selected Worksapce & Table

Airtable Sheets Data

This Template allows you to fetch data from your Airtable account into a Google Sheet. You can select your base or Workspace and select the Tables to fetch the record.

https://docs.google.com/spreadsheets/d/1mLJL4VlS2mVlZw31k3LuLj1ZC6cWG6m_DtCZyQvHgO8/copy

https://www.youtube.com/watch?v=LYUj0xfj90w

Dashboard for Production at Manufacturing Plant

Production Dashboard

For Manufacturing Plants

Output Dashboard

This is a dashboard for tracking Production at a Manufacturing Plant. This has a daily record of production based on products, operators and machines. Simple, easy to understand graphs gives you insight on trends in your plant.

https://docs.google.com/spreadsheets/d/1m6BbaBJRkmUnXCFIy0D32XQkN6-ZYwTMMW7StRjldXY/copy

https://www.youtube.com/watch?v=t1tkHlpwZJU

Google Sheet to get Monthly stock price from Alpha Vantage

Stock Price History

Monthly Value

Share Market Dashboard

If you are into stock market, this is a light weight tool to see monthly price history of any ticker between any two given dates. This uses Alpha vantage API, that has both free and premium key available.

https://docs.google.com/spreadsheets/d/15EnMwbsKfKqR5JcMsyc3Gnu9eFCHwHd2WOKYlr9CD-E/copy

https://www.youtube.com/watch?v=sNe8CbwskG0

Automated Wishes

To your Team Members

Birthday Anniversary Team

This System enables you to send Birthday and other wishes automatically with custom messages, so your team members feel special.

https://docs.google.com/spreadsheets/d/1K6TvdVRl3w4tWgOjrzWkm05WY7O7_AHWltLDqqvTp58/copy

https://www.youtube.com/watch?v=6gLTXyZrpSg