In this tutorial, we will use the Squarespace New Submission as our sample data. Squarespace doesn’t store the New Form Submissions but instead offers several options on how you can collect the submitted data outside their platform. We will use the Google Drive option and store them in the Squarespace Google Sheet.

  1. Set Up Google Sheets
  2. Select Squarespace as the Spreadsheet
  3. Test the Trigger
  4. Use PDF.co PDF Filler Function
  5. Configure PDF Filler with the Google Sheet Data
  6. Test & Review
  7. Download PDF and Copy & Paste URL to Browser

Squarespace Storage Options
Screenshot of Squarespace Storage Options

New Form Submissions will automatically be added as a New Spreadsheet Row in the Google Sheet.
Squarespace Submission Google Spreadsheet
Screenshot of Collected Data from Squarespace in Google Sheet

We will use this sample PDF to fill with the New Form Submissions from Squarespace Web Form.
Sample PDF Source File
Screenshot of Sample PDF Source File

Now that we know where our data is collected from and where we will use it, let’s get started.

Step 1: Set Up Google Sheets

Kindly choose Google Sheet as the App and New Spreadsheet Row as the Trigger Event.

Use New Spreadsheet Row As Trigger

Step 2: Select Squarespace as the Spreadsheet

Next, let’s select Squarespace as the Spreadsheet since that is where we want to store all the New Submissions data and choose Sheet1 as the Worksheet.

Setup Google Sheet Trigger

Step 3: Test the Trigger

Then, let’s test our Trigger to make sure that our account is configured correctly.

Google Sheet Trigger Test Successful

Step 4: Use PDF.co PDF Filler Function

We are now ready to setup the PDF.co. Kindly choose PDF.co as the App and PDF Filler as the Action Event.

Set PDF.co PDF Filler As The Action Event

Step 5: Configure PDF Filler with the Google Sheet Data

    • In the Source PDF field, enter the PDF URL.

I used the Sample PDF that I stored in my PDF.co File Storage. Check out this tutorial to see how the PDF.co built-in File Storage works.

    • In the Text Objects field, type in the x and y coordinates, page number, Google Sheet data, font size, and font name separated by a semi-color in this format: x;y;pageNumber;text;fontSize;fontName

You can use the PDF.co Simple PDF Viewer to easily get the x and y coordinates.

Configure PDF Filler With Google Sheet Data

Step 6: Test & Review

Now, let’s send the PDF Filler data to PDF.co to Test & Review.

Send PDF Filler To PDF.co To Test And Review

Step 7: Download PDF and Copy & Paste URL to Browser

PDF.co returned a temporary URL to view or download the PDF. Kindly copy and paste the URL to your browser to see the result.

PDF Filler Test Successful

Great! We have successfully filled the PDF with Squarespace New Submission data.

Fill PDF Output
Screenshot of PDF Filled With Squarespace Data

In this tutorial, we learned how to store the Squarespace New Form Submissions to Google Sheet. We configured the Google Sheet to make the collected data accessible to PDF.co. And, we used PDF.co to fill a PDF with the New Submissions data.

NOTE: You can set up the next step to save the generated file in Google Drive or Dropbox depending on your requirement.