Sitemap
Amit Agarwal

Amit Agarwal

Google Developer Expert for Google Workspace with Google Apps Script. I build things for the Internet.

Send Personalized Pre-populated Google Forms

1 min readJun 1, 2020

With pre-filled Google Forms, you can use existing data in your Google Sheets to auto-fill one or more form fields and send out personalized forms and surveys.

Get Amit Agarwal’s stories in your inbox

Join Medium for free to get updates from this writer.

Your clients are also more likely to complete the forms since they have a lesser number of fields to type and it feels more personal when they see their own information pre-populated in the Google Form.

The unique pre-filled Google Form links can be generated in your Google Sheets using the SUBSTITUTE function.

Press enter or click to view image in full size
Prefilled Google Form responses
Prefilled Google Form responses

--

--

Amit Agarwal
Amit Agarwal

Written by Amit Agarwal

Google Developer Expert for Google Workspace with Google Apps Script. I build things for the Internet.