Want to Read Faster? Change your Default Font In Google Docs

Google has added a new font family – Lexend – that will help you read faster and better. The font is available inside Google Docs, Sheets and Google Slides or you can download it directly from the Google Fonts website and use it in offline apps like Microsoft Word.

Here’s a sample Google document rendered with the Lexend Deca font.

speed-reading-fonts.png

Thomas Jockin and Bonnie Shaver-Troup, the font designers, have also uploaded the font files on Github under the Open Font License which allows you to use, modify and redistribute the fonts freely as long as they are not sold by themselves.

To enable the Lexend font in your copy of Google Docs, open a new document inside Google Docs, click the Font dropdown in the toolbar and select More Fonts. Search for Lexend and select them to add them to your default font list.

google-lexend-font.png

The study suggests that students were able to increase their reading speed (total number of correct words read per minute) by 19.8% when the same document was formatted in the Lexend typeface vs the Times New Roman family. The font’s development has been financed by Google.

The post Want to Read Faster? Change your Default Font In Google Docs appeared first on Digital Inspiration.

Make Instagram Slideshows with Google Slides

I just discovered an interesting use of the Instagram platform courtesy Addy Osmani – you can publish how-to guides and tutorials on Instagram as photo slideshows. To give you can an example, here’s an Instagram Slideshow that walks you step by step though the creation on Memojis on an iPhone.

People can swipe through your slides inside the mobile app of Instagram or the Instagram website on the desktop. They can like or comment on your post. And you can also embed your Instagram slideshows inside webpages and blogs with few lines of HTML – see one below.

How to Create Instagram Slideshows

A slideshow on Instagram is, in simple English, a gallery of 10 images uploaded in a single post. You can upload slideshows on Instagram from your iPhone or Android app.

You can use apps like Photoshop, Canva to prepare images for the slideshow or if you want something more convenient, try Google Slides. Here’s how:

Go to slides.google.com and create a new Google Slide (you can even upload an existing PowerPoint presentation). Here’s a sample presentation to help you get started.

export slide photos

Inside the presentation, go to File > Page Setup and choose a custom size equal to 1080×1080 pixels for a square presentation. Instagram supports photo sizes with aspect ratio between 1.91:1 and 4:5, so you can choose your canvas size accordingly.

You can insert up to 10 slides in your presentation. Next, go to the Addons menu and launch Creator Studio. Inside the sidebar, choose 1080 for the width and select “Image Sequence” as the export format. Click the “Go” button and it will create a new folder in your Google Drive with all the slides saved as high-resolution PNG image files.

instagram slideshow

Now open the Google Drive app on your iPhone or Android and download all the slide images to the photos folder on your phone. Launch the Instagram App, upload the images in a single post, and you’re done!

Also see: Save Google Slides as a Video File

If you were wondering why we had to go through the Google Drive route, that’s because Instagram API doesn’t allow photo uploads so they have to be uploaded manually.

The post Make Instagram Slideshows with Google Slides appeared first on Digital Inspiration.

How to Download your Google Slides Presentation as a Video File

With Microsoft Powerpoint, you can easily convert your presentation decks into high-resolution video files for uploading to YouTube and other video sites. The exported video files can also include all the voice narrations and background audio that you may have included in the presentation.

Google Slides doesn’t offer an option to save presentations as videos but there’s a new add-on in town – Creator Studio – that brings new export capabilities to your Google Slides. With Creator Studio, you’ll be able to save your decks as animated GIFs, image sequences and HD video (with audio).

Watch the video tutorial for a quick introduction.

To get started, go to creatorstudio.dev and install the Google Slides add-on. It requests certain permissions as it has to read the presentation images for converting them into movies. It also requires access to creating files in your Google Drive since the exported files are automatically uploaded to your Google Drive.

Once the add-on is installed, open any deck inside Google Slides that has at least 2 or more slides. Go to the add-ons menu, choose Creator Studio and it will open up a sidebar.

Specify the width of the output file in pixels. Creator Studio will auto-calculate the height to maintain the original aspect ratio of the presentation. Next, specify the time interval (in seconds) and this is the duration for which each slide would be visible in the video before advancing to the next slide.

google-slides-video-convert.png

Finally, you have a variety of export options to choose from that are not available natively inside Google Slides.

GIF Image

An infinite looping animated GIF image is created that is perfect for sharing inside email messages and blog posts. You can even make stop motion animations by keeping the time interval very low (say 0.2 seconds).

Image Sequence

Creator Studio will capture screenshots of each slide in your presentation and save it as a numbered PNG file in your Google Drive folder. Internally, it uses the Google Slides API to generate these thumbnail images.

MP4 Video

Like the GIF image, Creator Studio will produce an MP4 video file from your deck and you can also vary the time interval between slides.

Video with Audio 

You can upload any audio file in MP3 or WAV format and it will play alongside the presentation. You can upload background music or even voice narration that will play in the background while the video is playing.

google-drive-slides.png

Install Creator Studio

The post How to Download your Google Slides Presentation as a Video File appeared first on Digital Inspiration.

How to Email Spreadsheets Automatically on a Recurring Schedule

Introducing Email Spreadsheets, a Google Sheets add-on that lets you automate the reporting of spreadsheet data and dashboards by email. If you are an office worker who has been emailing spreadsheets to colleagues manually, this add-on will save you a ton of time. And because it runs on the Google Cloud, your spreadsheet reports will be delivered even while you are offline or on vacation.

With Email Spreadsheets, you can schedule reports and it will automatically send them by email on a recurring schedule. You can email entire workbooks, specific sheets inside a workbook or even range of cells. Watch the video tutorial to get started.

Email Google Sheets Automatically

Go to the Google add-on store and install Email Google Sheets. Next, open any Google Spreadsheet in your Google Drive, go to the Add-ons menu inside the sheet, choose Email Spreadsheets from the dropdown and then choose Rules to create your first scheduled email report.

You are presented with a 3-step wizard to help the email schedule of your spreadsheet report.

Step 1: Select Sheet Export Options

Google Sheet - Export Options
  1. Expand the “Select Sheets” dropdown and select one or more sheets that you would like to include in the email. Each sheet is attached as a separate file in the email but you can choose the “Merge all sheets” option to create a single file from all sheets in the workbook.
  2. Select the export format. You can choose between PDF, Excel (xlsx), OpenDocument or CSV formats. The “Email without Attachment” option can be used to embed a specific range of cells in the email body without including any sheet as an attachment.
  3. If you have selected PDF as the export format in step 2, you are presented with a few more options. For instance, you can change the paper orientation (Portrait or Landscape), the paper size or alter the print margins to fit more content on a page. You can choose to show gridlines, notes, sheet names and page numbers in the exported file.
  4. (optional) The Cell Range option lets you specify a range in A1 notation and only that range will be exported in the PDF file.

Tip: Use the Preview button to test how your exported files would be like with the various export options.

Step 2: Write the Email Template

Email Template with Dynamic Sheet Cell Values

Next, we create an email template that will be sent with your reports. You can specify one or email recipients in the TO, CC, or BCC fields. Multiple email addresses should be separated by a comma.

You can also specify dynamic email recipients based on cell values in the spreadsheet. For instance, if the email address of the recipient is specified in cell B2 of a sheet titled “Employee Shifts”, you can put {{Employee Shifts!B2}} in the To field, and the add-on will pull the dynamic value from the cell at the time of sending the email report.

These dynamic cell values enclosed inside double curly braces can be used inside any of the email fields including subject, email body, and the sender’s name.

The email body can include dynamic cell values as well as ranges that make it easy of you to send portions of the spreadsheet without sharing the full workbook. For instance, you can write {{Employee Wages!B2:F9}} to include only the specific range (B2:F9) from the Wages sheet. Internally, the add-on converts the range to an HTML table, retaining all the display formatting with CSS, and embed it into the email.

You can also include standard HTML tags like H1, IMG, A, B, EM and more to include images and rich formatting in your emails.

Tip: Use the Test Email button to send an email with the exported files before setting up the schedule.

C: Create the Email Schedule

Email Sheets Daily, Hourly, Weekly or Monthly

The Google Sheets add-on includes a scheduler to help you set up recurring schedules visually. You can send email hourly, daily, weekly, monthly or even on a yearly recurring basis.

It is also possible to setup advanced schedules like:

  • Send a recurring email on the last working day of the month.
  • Send email reports every alternate day and end the reporting after 15 days.
  • Set up a quarterly schedule and send email reports on the first Monday of the quarter.

That’s it. After specifying the schedule, hit the Save button and your email report will be scheduled.

If you would like to edit your current email report or schedule a new report, go the add ons menu again, choose Email Spreadsheets and Rules.

Download Email Sheets

Email Google Sheets – How it works?

The add-on is written in Google Apps Script. It uses the Google Sheets API to convert sheets to PDF files and uses the Gmail API for sending the converted files as attachments.

The post How to Email Spreadsheets Automatically on a Recurring Schedule appeared first on Digital Inspiration.

How to Track your Study Time with Google Forms and Sheets

In most organizations, employees are required to fill timesheets every week so the company can track the amount of time that people have spent working on various projects and tasks.

My kids are in middle/high school and I’ve been looking for a timesheet-style solution that would help me understand their studying patterns and learn how much time they spend on various subjects.

There are quite a few apps available for time tracking but I was looking for something simple and Google Forms fit the bill perfectly. The multiple-choice grid question is handy for quickly marking the time that they have spent on various subjects. I also added a Linear scale question for them to self-evaluate their daily screen time on a relative scale.

Here’s how the final study log form looks like:

Student Study Logs

The Email Form Notifications add-on is enabled for this Google Form so parents get an instant email when the boys submit the study log form. The email contains all the form answers in a neatly formatted table. An instant push notification is sent on the mobile phone as well with IFTTT.

Google Forms write all the form responses in a Google Spreadsheet and that makes it even easier to analyze the study pattern visually. You can use one of the available charts or hit the “Explore” button in Google Sheets and ask questions in natural English about the answers stored in your spreadsheet.

For instance, you can say “Sum of Subjects [Physics] by Name last week” and it will instantly tell you the amount of time that each kid has spent on that subject last week. Or say “What percentage of Subjects [Physics] is not empty where name is Aryaman” to know the percentage of days when he touched a particular subject.

Google Sheets Charts

And because Google Forms work just fine on mobile devices, students can quickly fill the time log anywhere as long as they know the form’s URL.

The post How to Track your Study Time with Google Forms and Sheets appeared first on Digital Inspiration.

Google Apps Script for Developers

Google Apps Script makes it is easy for you to integrate data and functionality from Gmail, Google Drive, Google Maps, YouTube, and most other Google APIs. Apps Script is JavaScript under the hood so you don’t have to learn a new language and you don’t have to manage any servers since all your code runs on the Google Cloud, not your browser.

In this video tutorial, you’ll learn how to develop Google Apps Script projects locally on your computer inside Visual Studio Code. You can write your code in modern JavaScript, neatly organized in modules, and the build environment will use Babel and Webpack to transform your code into a version of JavaScript that is compatible with Apps Script.

Modern Development with Google Apps Script

There are quite a few advantages with having a local development environment vis-a-vis writing code in the Apps Script Cloud IDE.

  1. You can write code with ES6 Classes, Arrow Functions, Modules, Destructing and use all the other modern JavaScript features.
  2. The development experience inside VS Code is unmatched and tools like ESLint and Prettier make it easier for you to catch errors early in the development.
  3. The build and deployment process can be completely automated with npm scripts and CLASP, Google’s command line utility for Apps Script.
  4. VS Code has built-in support for Git and integrates with source control providers like Github and Gitlab. It is therefore easier to track changes and restore previous versions of the code.
  5. You can quickly integrate JavaScript libraries like LoDash, Moment, Underscore and any of the NPM packages into your code.
  6. You can use modern frameworks like React, Vue.js and Angular to build the HTML frontend that connects to the backend with the Google Script Client API.

Getting Started with the Apps Script Starter

The Starter kit is a boilerplate for quickly getting started with local Apps Script development locally inside VS Code. Open your terminal and run the following commands:

1. Clone the Github repository to a local folder

git clone https://github.com/labnol/apps-script-start my-project

2. Switch to the project folder

cd my-project

3. Install all the project dependencies and utilities

npm install

4. Connect CLASP to your Google account

npx clasp login

5. Create a new Google Apps Script project in your Google Drive with CLASP

npx clasp create "My Project" --rootDir ./dist

This command will create a new .clasp.json file in your project folder that links the local folder with your Apps Script project. During build, Webpack will bundle all your code in a single JavaScript file and add it to the ./dist folder that Clasp will push to your Apps Script project.

Next, open the current project folder inside VS Code with the code . command. It includes some sample code but we will start with a blank folder so delete everything that’s inside the src folder.

Inside the src folder, create a new file – email.js – and write a simple arrow function that prints a list of all the email addresses connected to your Gmail account.

apps-script-starter (1).png

Next, create an index.js file (entry point) in the src folder, import the email function that you’ve created inside the email.js file and add it to the global object. This is a requirement of the Webpack plugin for Google Apps Script.

You can also add a function expression to the global object directly, like doGet in the example below.

htmlservice-doget.png

Now that your JavaScript code is ready, open the appsscript.json file in your project folder and modify the oAuthScopes property to only include the scopes that are required by your project.

Next, jump to the command line terminal and run the deploy command to push your code to the Apps Script project.

npm run deploy

After the deployment is complete, open the associated script in the browser with the CLASP open command.

npx clasp open

Inside the Apps Script Editor, go to the Run menu and choose the getEmailAddress function from the list. Open the logs and you should see your email addresses in the window.

Then go to the Publish menu, choose Deploy as web app and open the URL in a new browser tab to check the program output. That’s how easy it is to build projects with the Google Apps Script starter kit.

Using Git with Google Apps Script

Create a new repository in Github and make a note of the URL of the new repository. Next, open the terminal and run the following commands to push your Apps Script project to Github.

github-apps-script.png

Also see: Most Useful Google Apps Scripts

The same approach is used by Digital Inspiration for building popular Google add-ons including Gmail Mail MergeGoogle Forms Notifications and Document Studio.

The post Google Apps Script for Developers appeared first on Digital Inspiration.

The Essential Tools for Programmers

This is a list of essential tools and services from my coding workflow that I think should be part of every web programmer’s toolkit. Whether you a building a simple “Hello World” app or a complex web application, these tools should make your coding easier and increase productivity.

programmers-toolkit.jpg

The Web Developer’s Toolkit

1. devdocs.io — API documentation for all popular programming languages and frameworks. Includes instant search and works offline too.

2. glitch.com — create your own web apps in the browser, import GitHub repos, use any NPM package or build on any popular frameworks and directly deploy to Firebase.

3. bundlephobia.com — quickly find the import cost (download size) of any package in the NPM registry. Or upload your package.json file to scan all dependencies in your project.

4. babeljs.io/repl — Write your code in modern JavaScript and let Babel transform your code into JavaScript that is compatible with even older browsers.

5. codeply.com — quickly build frontend responsive layouts with frameworks like Bootstrap, Materialize CSS and SemanticUI.

6. httpie.org — a command-line tool that is useful for making HTTP requests to web servers and RESTful APIs. Almost as powerful as CURL and Wget but simpler.

7. regexr.com — A good tool for testing your regular expressions in the browser.

8. jex.im/regulex — Write any regular expression into the editor and get a visual representation of how the pieces work.

9. buildregex.com — Construct regular expressions visually.

Also see: The Most Useful Websites on the Internet

10. explainshell.com — Type any Unix command and get a visual explanation of each flag and argument in the command.

11. tldr.ostera.io — Unix man pages are long and complex. This site offers practical examples for all popular Unix command without you having to dive into the man pages.

12. mockaroo.com — quickly generate dummy test data in the browser in CSV, JSON, SQL and other export formats.

13. jsdelivr.com — Serve any GitHub file or WordPress plugin through a CDN. Combine multiple files in a single URL, add “.min” to any JS/CSS file to get a minified version automatically. Also see unpkg.com.

14. carbon.now.sh — create beautiful screenshots of your source code. Offers syntax highlighting for all popular languages.

15. wakatime.com — know exactly how long you spend coding with detailed metrics per file and even language. Integrates with VS Code, Sublime text, and all popular code editors.

16. astexplorer.net — paste your JavaScript code into the editor and generate the Abstract Syntax Tree that will help you understand how the JavaScript parser works.

17. hyper.is — A better alternative to the command line terminal and also iTerm. Use with the Oh My Zsh shell and add superpowers to your terminal.

18. curlbuilder.com — make your own CURL requests in the browser.

19. htaccess.madewithlove.be — easily test the redirect and rewrite rules in the .htaccess file of your Apache server. See useful .htaccess snippets.

Also see: The Best Places to Download HTML Templates

20. trackjs.com — monitor errors in your JavaScript based web projects and get instant email notifications when a new error is detected.

21. ngrok.com — Start a local web server, fire up ngrok, point to the port where the localhost is running and get a public URL of your tunnel.

22. codeshare.io — An online code editor for pair programming, live interviews with video conferences or for teaching code to students remotely.

23. webhooks.site — Easily inspect the payloads and debug HTTP webhooks in the browser. All HTTP requests are logged in real-time. Another good alternative is RequestBin.

24. surge.sh — the easiest way to deploy web pages and other static content from the command line. Supports custom domains and SSL. Also see Zeit Now.

25. visbug — A must-have add-on for web developers that brings useful web design tools right in your browser. Available for Google Chrome and Firefox.

26. puppeteersandbox.com — Puppeteer is a Node.js framework for automating Google Chrome. Use the sandbox to quickly test your scripts in the browser. Also see try-puppeteer.com.

27. prettier.io/playground — Beautify your JavaScript and TypeScript code using Prettier, the favorite code formatter of programmers.

28. json.parser.online.fr — The only JSON parser you’ll ever need to analyze and beautify your complex JSON strings.

29. scrimba.com — Create your own programming screencasts in the browser or watch other developers code.code.

30. katacoda.com — A training platform for software developers where anyone can create their own dedicated and interactive training environments.

31. codesandbox.io — A full-featured online IDE where you can create web applications in all popular languages including vanilla JavaScript, React, TypeScript, Vue and Angular. Also see StackBlitz.com and Repl.it.

32. apify.com — Write your own web scrapers using JavaScript and schedule your scrapers to run at specific intervals automatically.

33. vim-adventures.com — The Vim text editor is hugely popular among programmers. The site will help you master the various key commands through a game.

34. insomnia.rest — A desktop based REST client that lets you create HTTP requests and view response details all in a easy-to-use interface. Advanced users may consider Postman.

Also see: The Most Awesome Teachers for Learning Web Development

The post The Essential Tools for Programmers appeared first on Digital Inspiration.

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.

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.