Google Sheets add-on

Form2PDF

Form2PDF takes a form-response row, fills a format tab you set up, and saves a PDF in a Form2PDF folder in your Drive. If you turn mail on, it sends that PDF to the address on the row.

Form2PDF runs in your Google account. Response data, the format, and the PDFs stay in your spreadsheet and your Drive. Gentle Reminder does not receive that data.

Form2PDF privacy Form2PDF terms Contact

How it runs

One row becomes one PDF.

Set the format

Choose the response tab, the format tab, the print area, and the column-to-cell mapping.

Run

Run makes the PDFs that are still waiting and saves them in a Form2PDF folder in your Drive.

Schedule or mail

A schedule can run when a form response arrives, or during a daily or weekly hour. If mail is on, the PDF goes to the address on the row.

In the sheet

The responses stay where they are. The PDF is a print of a tab you design.

A Google Sheet of form responses with the Form2PDF sidebar open beside it — The response tab stays in the sheet. Setup opens beside it.

Form2PDF setup for the format tab, print area, paper size, and landscape direction — The format tab is the layout. You mark the print area and the paper.

Mapping each response column to a cell on the format tab — Each answer is written into the cell you choose. A formula on the format tab can read that cell.

File name pattern for the PDF saved in the Form2PDF Drive folder — The PDF is saved in a Form2PDF folder in your Drive. A timestamp is added to the name.

Email step with mail turned on and the address taken from the Email column — Mail can stay off. When it is on, the PDF is attached and sent to the address on that row.

Certificate of completion printed from a Form2PDF format tab, with the name, course, grade, and certificate ID filled in — This certificate is one example. The layout is whatever you build on the format tab. Form2PDF fills the mapped cells and prints that area.

Schedule choices: no schedule, when a form response arrives, every day, or every week — Run it from the menu, or when a response arrives. A daily or weekly run starts during the hour you pick, India time.

Mail preview addressed to the first response, with the certificate PDF named as the attachment — The preview uses the first response row. The PDF is attached. The Drive file is not shared as a link.

FAQ

Common questions

How customizable is the format?: The PDF is a print of a sheet tab you design. Fonts, colours, images, merged cells, and formulas are whatever you put on that tab. Form2PDF writes each answer into the cell you choose, then prints the area you mark. The layout is an open canvas in the sheet.
Is there one format for every response?: Yes. The spreadsheet uses one format tab and one print area. Each response row is written into that same layout, then printed.
Can the format use formulas?: Yes. A formula on the format tab can read the cell where an answer was written. The PDF shows the calculated result.
Where are the PDFs saved?: In a Form2PDF folder in your Drive. The add-on creates that folder. The files stay in your Google account.
Can it email the PDF?: Yes, if you turn mail on. The message goes to the address on that response row, with the PDF attached. You can leave mail off and only save the file.
When does it run?: From the Form2PDF menu, with Run. A schedule can run when a form response arrives, or sometime during an hour you pick, every day or every week. A daily or weekly run starts during that hour, India time. It cannot start at an exact minute.
Where does the response data go?: The response rows, the format, and the PDFs stay in your spreadsheet and your Drive. Gentle Reminder does not receive them.

Questions: contact us or hello@gentlereminder.in.