Privacy Policy – Email Address Extractor

Screenshot 2019-02-07 at 6.55.32 PM.png

Why Add-on Needs Permission to Access your Google Account

The Email Address Extractor add-on requires access to certain services in your Google Account. Here we explain why these permissions are required and how the add-on manages your data.

Google Add-ons Permissions Explained

1. See, edit, create and delete your spreadsheets in Google Drive 

The add-on is available inside a Google Spreadsheet and you manage all the settings from inside Google Sheets. The add-ons also logs all the extracted email addresses in a Google Spreadsheet. It will never read or delete any spreadsheet in your Drive.

2. Manage mailbox labels

The add-on lets you select any Gmail label (folder) from the list of available labels and extracts all emails inside that label to your Google Sheets. It only reads the list of your Gmail labels and will never delete or modify any label.

4. View and modify but not delete your email

The add-on needs access to your email to read the message body, the header and extract any email addresses found in the email to your Google Sheet. It will only read your email and never delete or send any email. It applies the label “Extracted” to email messages that have been processed and thus needs permissions to modify the email.

5. Connect to an external service 

The add-on connects to the license server to verify your license key and provide access to premium feature to paid users.

6. Allow this application to run when you are not present

The add-on can extract email addresses in the background even while your computer is turned off. It create a time-based clock trigger that executes automatically at specific intervals on Google servers.

7. Display and run third-party web content in prompts and sidebars inside Google applications

The add-on is available inside your Google Spreadsheet contained in a sidebar. You can manage all the rules and manually run the download process from the sidebar.

Email Address Extractor - Privacy Policy

Please read our privacy policy.

  • The app will not collect your information only with your consent; it only collects the minimum amount of information that is necessary to operate the add-on.
  • No humans will read any of your data including email messages. If you require technical help, the app may ask you to share your add-on settings with the developer for support.
  • The app will not store your data on non-Google servers. All your settings are stored on Google servers inside the property store of the Google project associated with the addon.
  • The app will not use any of your data for market research, advertising, serving personalized content, retargeting, or recommendations.
  • The App will only use access to read, and modify Gmail message bodies (including attachments), metadata, headers, and settings to extract email addresses and will not use your data for any other purpose.
  • We will not transfer or share your information with others unless doing so is necessary to provide and improve these features, comply with applicable law, or as part of a merger, acquisition, or sale of assets.

Google sign-in will authenticate your identity and provide you the option to share certain personal information with us such as your email address. The information you provide is held in strict confidence. We collect this information to generate your user license, send payment receipts and communicate with the user about product updates.

If your personal information changes, or if you no longer desire our service, you may delete or deactivate it by uninstalling our Google add-on or by contacting us. We will respond to your request within 5 business days.

We use other third parties payment processor, such as PayPal, Instamojo, Paddle, WooCommerce and Stripe, to bill you for services and a live chat service to assist you if you have questions while using our website or regarding your order. We neither store nor have access to your credit card details.

If you have any questions or suggestions regarding our privacy policy, please contact us via email at amit@labnol.org.

Find Public Restrooms Near Your Current Location

Public Toilets and Bathrooms - Google Maps

If you are traveling in a new location, the public toilets and bathroom finder option avaialble inside Google Maps could come in very handy.

Open the Google Maps on your phone (or open maps.google.com on your desktop browser), make sure that the location services are turned on and type the query public toilets near me.

Google Maps will instantly show you the location of restrooms near your current location.

The feature also works inside Google Assistant. Say “OK Google” to activate the Assistant, say the command “Show me toilets near me” and it will open maps with placemarkers for all the toilets near your location.

If location is unavailale on your phone, or if you wish to learn about restroom in a particular location without actually being there, change your search query to use the address instead of near me.

Your query in that case will be show toilets near Taj Mahal in Agra or Public Restrooms in Times Square or Where can I find a bathroom in NYC.

In India alone, more than 57k toilets and restrooms in urban India can be found through Google Maps. If you are mobile phone user in India, you can call the toll-free number 000 800 9191 000 from your Vodafone / Idea mobile and enquire about public toilets near your location.

YouTube Uploader – Let Others Upload Videos to your YouTube Channel

It is easy to upload videos to your own YouTube channel but there’s one limitation. Only the owner of the channel can upload videos to their YouTube account and they cannot delegate the task to someone else in the team.

Google Drive has the concept of shared folders. A folder can have multiple collaborators and anyone can upload files to that folder. Wouldn’t it be useful if such a feature were available for YouTube channels as well? You maintain a single YouTube account and multiple people can upload videos to your common account without the owner having their the Google account credentials with anyone.

youtube-video-uploader.png

YouTube Video Uploader for Collaboration

Introducing YouTube Uploader, a simple file upload form that lets anyone upload videos to your YouTube channel from their desktop or mobile phone. The uploader doesn’t even need a Google account and they’ll still be able to upload video files of any size to your YouTube channel.

Before we get into the implementation details, open this live demo page and upload a video file. Once the file is uploaded, YouTube will take a minute or two to process the video and it will go live immediately on the YouTube channel.

Make your Own YouTube Uploader

If you have a collaborative YouTube channel with multiple contributors, you may consider setting up your own private YouTube Uploader form and any of the contributors will be able to upload their work on your channel directly via the form.

Here’s how you can build a YouTube uploader in 3 easy steps.

  1. Click here to make a copy of the YouTube uploader script in your Google Drive. It is recommended that you create a new Google account to test the YouTube uploader before using it with your main account.
  2. Enable the YouTube API for your Google project. Go to Resources > Cloud Platform Project, click the project name and enable the YouTube Data API from the API library. Watch the video guide for details.
  3. While inside the script editor, go to Publish > Deploy as Web App and click Update.
  4. You’ll be presented with an authorization screen as the script needs permission to upload videos on your behalf and also send email notifications when a new video is uploaded. Click Allow.

That’s it. You’ll be presented with a unique URL that you can share with your team members.

The user is presented with a simple web form where they can fill in the video title, description, the video category, and the privacy mode (should the video be private,  public or unlisted). All they have to do is select a file and click “Upload” to send the video to your YouTube channel directly.

YouTube Uploader Settings

Important Points to Know:

  • When deploying the web app,  choose “Me” under the “Execute the App as” section and “Anyone, even anonymous” under the “Who has access to the app” section.
  • If you would like to disable the uploader, go to Resources > Deploy as web app and choose “Disable web app.”
  • The uploader is written in JavaScript (ES6) and compiled to Google Apps Script with Babel, Clasp and the Apps Script starter kit.
  • Keep the YouTube Uploader URL secret and only share with people you know.
  • This program comes as it is with no warranty. It may not be used for commercial applications.

The post YouTube Uploader – Let Others Upload Videos to your YouTube Channel appeared first on Digital Inspiration.

How to CC and BCC Email Addresses in Google Forms

The Email Notifications add-on for Google Forms lets you send emails to one or more addresses when someone fills and submits your Google Form. All the specified email addresses are included in the TO field of the email message but if you are a premium user, you also have an option to specify email addresses in the CC and/or BCC field of the email message.

This is useful is multiple scenarios. For instance, if you are school, you can choose to automatically BCC all form emails to the class teacher. Or if you are in a company using Google Forms for receiving customer requests, you can use CC to notify all the team members in the same notification.

To get started, go to the Google Forms add-on menu and choose Create Email Notifications. If you have set up a rule ready, choose Manage Form Settings to edit the existing notification.

Google Forms BCC and CC

Here, if you are a premium user, you’ll see additional fields for CC and BCC as shown in the screenshot. You can put one more email addresses in the field, separated by commas, and it also supports dynamic fields where the value is replaced by the actual answer from the form.

For instance, if your question title is “What is the manager’s email?”, you can put the question in the cc field as {{What is the manager’s email?}} and they’ll be CC’ed in every email notification. The question title and {{placemarker}} should match exactly.

If you have used any conditional emails in Google Forms, where the email is sent to a different recipient based on form answers, those matching email addresses are always included in the TO field of the email notification.

The Most Awesome Online Teachers for Learning Web Development

For the past few months, I have been on a learning spree looking to enhance my existing coding skills and also learn new programming languages and frameworks. In this process, I have watched a countless number of video tutorials and online courses that pertain to programming and, specifically, web development.

In my quest to become a better developer, I’ve come across several awesome “teachers” who aren’t just excellent programmers but awesome educators and have the art of explaining complex and difficult concepts.

Learn Modern Web Programming with the Best Online Teachers

This is an attempt to highlight the best instructors on the Internet for JavaScript, React, Redux, Node.js, Firebase (database and storage), Docker, Google Golang, Typescript, Flutter (for mobile app development), Dart, Git, Webpack and Parcel bundler.

I’ve taken courses by every single instructor mentioned here (PDF) and recommend them highly.

Awesome Web Teachers
Language / PlatformTeacher / Course
React.jsAndrew Mead, Maximilian Schwarzmüller, Stephen Grider, Ryan FlorenceScott Tolinski, Elijah Manor, Brian Holt, Dave CeddiaKirupa Chinnathambi
Advanced JavaScript / ES6 / ES2017Anthony Alicea, Wes Bos, Mark Zamoyta, Tyler McGinnis,  Mosh HamedaniKent C. DoddsKyle SimpsonKyle Robinson YoungBrandon Morelli, Cody Seibert
ReduxDan AbramovShaun PellingBucky RobertsCory House
Dart & FlutterMary Xia & Matt SullivanStephen Grider, Maximilian Schwarzmüller, Filip & Emily Fortuna
Docker / KubernetesJake Wright, Stephen Grider, James Lee
Webpack / Parcel web bundlerAndrew MeadLawrence Whiteside, Sean LarkinPetr TichyBrad TraversyMax Schwarzmüller
Node.jsMaximilian SchwarzmüllerStephen GriderAndrew MeadAzat MardanAnthony AliceaSamer Buna
Git & GithubTrevor MillerAlex Garret-SmithTom Preson-Werner, Daniel Shiffman
Go LanguageTodd McLeod, Stephen Grider, Derek Banas, Jon Calhoun, Harrison Kinsley
TypeScriptTodd MottoJohn LidquistBasarat Ali SyedMarius Schulz
Firebase / FirestoreDavid East, Doug Stevenson, Shaun Pelling, Todd Kerpelman, Steve Kinney
Google Chrome Dev ToolsPaul Irish, Surma, Umar Hansa, Jon Kuperman
GraphQLAndrew Mead, Stephen Grider

Also see: Learn How to Code Online

The post The Most Awesome Online Teachers for Learning Web Development appeared first on Digital Inspiration.

How to Automatically Create PDFs with Google Form Responses

Google Forms are the best tool for creating online polls, surveys, quizzes, and questionnaires. The form submissions are automatically stored in Google Spreadsheets, making it easier for you to analyse the submissions, and your forms can receive an unlimited number of responses.

When a user submits your Google Form, a row is added to the destination Google Sheet with all the answers. The tutorial explains how you can save your Google Form responses in a customized PDF file in Google Drive and have it emailed automatically to one or more recipients via Gmail.

For this example, we are building an event registration form with Google Forms. The attendees fill the form, select the session(s) they wish to attend and an email confirmation is sent to them instantly. A PDF document is attached and it contains the form answers and also a dynamic QR Code that can be scanned at the event venue.

Create PDFs with Google Forms – DEMO

Before we get into the implementation details, please try the live workflow so you have a better idea of what we are building.

First, fill-in this Google Form and submit. Your form response is saved in this Google Sheet and, within a few seconds, you’ll receive a personalized email with a PDF attachment. It contains a QR code and a unique registration ID that is generated automatically with the =QRCODE() formula.

Internally, the workflow is using this Google Document to merge the Google Forms data into a PDF file. We picked PDF for this example but you can generate documents in any format including Word documents, Excel Spreadsheets, PowerPoint Slides, ePub and more.

How to Create PDF Documents with Google Form Responses

To get started, create a new Google Form and choose a destination Google Spreadsheet where the responses would get saved.

Next, create a template in either Google Docs, Google Slides or Google Sheets. In your template, the variable fields should be enclosed inside double curly braces and the field name should exactly match the question title in your Google Form.

Google Forms Merge Document

For example, if your Google Form question is “Full Name”, the marker in your document template would be {{Full Name}} and it will be automatically replaced with the answer submitted by the form submitter.

Install Document Studio

Next, install Document Studio for Google Sheets and authorize the add-on. Now open the Google Spreadsheet that is storing your Google Form responses, go to the Add-ons menu, choose Document Studio and open the sidebar to build the workflow.

First, expand the Document Merge section and choose the document template from Google Drive that you have created in the previous step. Choose a file name of the exported file – it can be a fixed name – like event.pdf – or a dynamic name like {{full name}}.pdf where the file name is customized based on file answers.

Next, expand the Mail Merge section in Document Studio’s sidebar, turn on the “Send Emails” option and create an email template using the built-in WYSIWYG editor.

HTML Email Template - Google Forms

You can customize the template by adding variable placeholders, like {{First Name}}, in the email subject and message body for personalized emails. Choose the field where you asking for the submitter’s email address to send them an email when they submit the form. You can add more emails (comma-separated) in the “Email Specific People” to notify more people when forms are submitted.

If you would like to add markers to the merged document that aren’t present in the Google Form, you can use the help of Google Sheets array formulas.

carbon.png

For instance, if your Google Form question is Full Name, you can add a new column in the Google Sheet for First Name and use the following formula to automatically get the first name from Google Form submissions that can be used in the email and document template.

Also see: How to Send Personalized Emails with Gmail

Finally, expand the “Finish and Merge” section and check the option Merge on Form Submit. Click Save to turn the workflow and submit a test entry in your Google Form.

merged-pdf-document.png

You should find a personalized email with the merged document as a PDF attachment in your Gmail sent items. A copy of the PDF file is saved in your Google Drive that you can use to automatically print the Google Form response via Google Cloud Print.

If you are stuck, please watch the video tutorial (download) for a visual walkthrough.

The post How to Automatically Create PDFs with Google Form Responses appeared first on Digital Inspiration.

Help Locate your own Email Message in Someone Else’s Gmail

You’ve sent an important email to a colleague but it is lost in the deluge of emails they receive every day, buried and forgotten. They can obviously use Gmail search operators, like FROM: or SUBJECT:, to locate that email later but wouldn’t it be useful if there were a way to directly locate that one missing email in their mailbox.

Well, there’s an alternate search trick and the sender can actually help the recipient find any specific email message that they have sent in the past.

When you send an email through Gmail, a unique Message ID is added to the email header as per the RFC 822 specification. To know the ID of your message, open the email inside Gmail, go to 3-dot menu and choose Show Original. The Message-ID will be displayed in the first line of the header as shown the screenshot.

gmail-message-id.png

The Message ID of a particular email message is exactly the same for both the sender and the recipient. That means if the recipient opens the header of your email in their mailbox, the message ID will match that of the message in your Gmail sent folder.

Gmail offers a lesser-known search operator – rfc822msgid – that helps you search emails by their message ID.

So if our message ID is xyz@mail.gmail.com, a simple search like rfc8222msgid:xyz@mail.gmail.com will return the exact email in search results.

RFC822 Message ID for Gmail

And that’s the trick. This search query will work for both the recipient and the email sender. So if you pass the message ID to the recipient, they can simply use the rfc822msgid operator to locate a specific email from you in their own mailbox.

Since the recipient ID is too complex, you can simply copy of the URL of the Gmail search page and pass them to the recipient. The URL will work for them as well since the Message ID is the same for them as well.

You can also use this search trick to bookmark emails in the browser.

Also see: Send Personalized Emails with Gmail

The post Help Locate your own Email Message in Someone Else’s Gmail appeared first on Digital Inspiration.

The Best Places to Download HTML Templates for your Website

Are you looking for responsive, beautiful and professional looking HTML templates for your next website but don’t have the budget? Well, here are a couple of free resources on the Internet where you can regularly find good templates for use in your web projects without restrictions.

dribble-html-templates.png

Dribble is a popular community of designers for them to showcase their work online. In addition to posting screenshots of their work, designers also upload the HTML / CSS version of their projects for anyone to use. You should bookmark the freebie and the freebies tag on Dribble to never miss these projects.

Creative Market is a marketplace for website templates, themes, fonts and other design assets. It is a paid store but if you join their email newsletter, they’ll send you free design stuff every week in your inbox that can be downloaded directly to your Dropbox. And they are mostly good.

HTML5 UP is created by the same developer that built Carrd, one of the most useful websites on the Internet. HTML5 UP is a treasure house of beautiful templates built sans the heavy Bootstrap or Material framework. All web templates are available in the Creative Commons license so can you can use them in any way with attribution.

website-theme

Envato’s Themes Forest is a premium marketplace for website templates but if create a free account with them, you get to download all the freebies that are published on their homepage every few weeks. These are paid items that the authors have made free only during the duration of the promotion to gain visibility in the marketplace.

OnePageLove is a curated directory of single page websites and they have a dedicated section for HTML templates that are free to download.

UpLabs is another online marketplace and community where creative designers share their work. The “web” section offers a variety of HTML templates that are free for both personal and commercial use.

html-podcast-layout.jpg

Manoela Ilic’s Codrops houses the most creative collection of work for web designers as well as developers. Every single project on this site, be it an image slider or a checkout page, is unlike anything you’ve seen before and the source code is up for grabs on Github.

Freebiesbug, as the name suggests, curates web freebies including fonts, PSD designs, stock photos and, of course, HTML templates. Look for the “exclusive” tag and you’ll discover HTML/CSS templates that the designers have chosen to share exclusively on this website.

And the final resource in my list that is worth adding to your bookmarks is Codepen. Chris Coyier started Codepen as a playground for writing HTML, CSS and JavaScript in the web browser but the project has evolved into a huge community of front-end developers that are putting the code in public which are free to fork and download.

PS: If you are aware of any good resource for free web templates that we missed in the above list, please let me know at amit@labnol.org – thanks!

The post The Best Places to Download HTML Templates for your Website appeared first on Digital Inspiration.

Make your own Saregama Carvaan with YouTube and Google Sheets

Saregama Carvaan, a digital music player that looks like an old-fashioned transistor radio and targets the non-millennial generation, has become a huge hit in India. The company analysed data from online music streaming sites like Saavn, Gaana and YouTube, came up with a catalogue of 5000+ “greatest” Hindi movie songs and pre-loaded them into Carvaan, classified by artists and moods.

Like a radio station, Saregama Carvaan mixes nostalgia with an element of surprise – the player’s algorithm plays music in a random sequence so the listener would never know which song is coming up next. Can the Carvaan experience be recreated with YouTube? Let’s find out.

1. The Songs List

A quick Google search on the Saregama website led me to this PDF document – it contains a complete list of every song that’s bundled into the Carvaan player. I imported the songs PDF into a Google Spreadsheet so the data could be easily filtered by movie names or artistes.

saregama-carvaan.png

2. The YouTube Database

The YouTube API lets you query the video database by keywords. I wrote a simple Google Script that reads the song titles from the Google Spreadsheet and finds the corresponding video on YouTube. The YouTube API returns the video link, the description, the channel of the video uploader and the thumbnail image (source code).

youtube-api-video.png

3. The Spreadsheet Formulae

Google Spreadsheet provides the IMAGE formula that helped me embed the YouTube thumbnail URLs as images into the spreadsheet cells. I used Array Formulas to apply the same formula to the entire column in the spreadsheet.

The YouTube video IDs were converted to the YouTube URLs again with the help of a simple array formula.

=ArrayFormula(CONCAT("https://youtu.be/",D2:D))

4. The YouTube Playlist

Now the spreadsheet was populated with a list of songs that are preloaded into Carvaan and their corresponding YouTube videos.

The next task was to create a YouTube playlist with all the videos. I had earlier built a tool for copying YouTube playlists and the same API was used here for building the playlist inside the spreadsheet (source code).

youtube-playlist.png

The Final Result

And here’s the final result – a YouTube playlist with 5000 songs that come bundled with Carvaan. Press the “Shuffle” icon and the songs would play in random sequence continuously.

saregama-carvaan-youtube-playlist.jpg

Useful Links

The post Make your own Saregama Carvaan with YouTube and Google Sheets appeared first on Digital Inspiration.

Email Studio adds Mail Merge and Email Scheduler Directly in Gmail

Introducing Email Studio, our new open-source Gmail add-on that brings powerful capabilities like mail merge, email scheduler, copier and more to your Gmail mailbox. Unlike other solutions, Email Studio works directly in Gmail and you can even use it inside the Gmail App on your Android phone (with support for iPhone coming soon).

Whether you need to send personalized emails to your Google Contacts, schedule emails in Gmail for sending at a later date, auto-forward emails to another address, you can do it all and more with Email Studio. Watch the video tutorial series on YouTube to get started.

Email Studio for Gmail – Features

Here’s a complete list of modules that are bundled with Email Studio.

Mail Merge – Create a Gmail draft, choose one or more Google Contacts and personalized emails will go out to each recipient with having to use CC or BCC.

Send Later – Compose an email now and the add-on will automatically send it later at preferred date and time later. You can also set up recurring schedules that will send the same email to the same recipients but multiple times on different dates.

Auto-Forwarder – Gmail has a built-in forwarder too but it only works on new email and you can only forward emails to email accounts that are your own. Email Studio imposes no such restrictions and it just works.

Email AutoResponder – Gmail has Canned Responses but with Email Studio, you can send auto-replies to both old and new email. Your responses can also include attachments which are not supported in Gmail Canned responses.

Email Unsubscriber – Quickly remove yourself from unwanted newsletters and bulk emails. This open-source utility won the ProductHunt Lifehack of the Year award and is now bundled with Email Studio.

Draft Copier – Quickly create or more identical copies of any existing draft in your Gmail mailbox. If you want to send similar emails to a bunch of people manually but without using CC or BCC, you’ll love the copier.

Email Purge – You can set up rules to automatically delete emails that match certain criteria. For instance, I could set up a rule to automatically delete emails that contain “breaking news” in the subject and the message is older than 7 days.

Inside Email Studio

Email Studio inside Gmail Mobile App

Mail Merge with Email Studio

Draft Copier with Email Studio

Cleanup with Email Studio

Install Email Studio

* Email Studio is free for basic usage. If you need to send more than 25 emails per day with Email Studio, please upgrade to premium. It has a higher daily email quota and includes no branding.

** Email Studio includes a simple version of Mail Merge that recognizes {{First Name}} and {{Full Name}} fields of Google Contacts. If you need to include more personalized fields, track email opens or send separate attachments to different recipients, check out the more advanced Mail Merge with Attachments add-on for Google Sheets.

The post Email Studio adds Mail Merge and Email Scheduler Directly in Gmail appeared first on Digital Inspiration.