Getting Started
Generate Files
Approval Workflow
Multiple Files Generation
Troubleshooting
Data Security and Policy
Billing

Customize PDF documents generated from Google Sheets

You can customize the paper size, page orientation, margins, and other options related to how Form Publisher generates PDF documents from a Google Sheets template.

Prerequisites

  • You must have a Google form configured with Form Publisher.
  • The template selected must be a Google sheet.
  • You must configure Form Publisher to generate a PDF document.

Procedure

  1. Start Form Publisher by clicking the Add-ons icon in your Google form and selecting Form Publisher.
    01-start-form-publisher.png

  2. In the pop-up menu, click Launch Form Publisher.
    02-launch-form-publisher.png
    The Form Publisher for Google Forms add-on starts in the lower-right part of the screen and opens the Template and markers page.
  3. Click the Menu button.
    03-fp-add-on-click-menu-button.png
    The Form Publisher menu opens.
  4. Select Sharing options and notifications.
    select-sharing-options-and-notifications.png

  5. Under More options, click PDF parameters.
    open-pdf-parameters-screen.png
    The Spreadsheet pdf parameters screen opens.
  6. Select the Activate PDF parameters checkbox.
    activate-pdf-parameters.png

  7. (Optional) Check the default parameters selected by Form Publisher.
    1. Under Global parameters, configure the Paper size and the Page orientation.
      select-paper-size-and-orentation.png

    2. Under Margin, you can select the Margin units and specify the margin you want at the Top, Right, Bottom, and Left of your document.
      select-margin-and-inches.png

    3. Under Formatting, enable some or all of the listed formatting options to customize generated PDF documents.
      1. Fit to width. Fits the content in the spreadsheet to the selected Paper size.
      2. Hide sheet name. Hides the sheet name from the generated PDF document.
      3. Hide title. Hides the Google sheet document title from the generated PDF document.
      4. Hide sheet number. Hides the Google sheet number from the generated PDF document.
      5. Hide gridlines. Hides the borders of the table cells.
        select-formatting.png

Result

Form Publisher is now configured to generate PDF documents with the configured customizations.
Example 1: The generated PDF document is displayed in a portrait format, and does not show the document title, the sheet title, and also the sheet number.
result-pdf-parameters.png
Example 2: The generated PDF document is displayed in a landscape format, the title is displayed and the gridlines are hidden.
result-pdf-parameters-2.png

Articles in this section

Powered by Zendesk