SquareSpace Form + Google Sheets Data Parsing and Data Extraction

Hello everyone!

I am trying to build a webpage on my SquareSpace site that will:

1. Prompt my customers to enter the serial number for a product that they bought from my shop into a form.
2. Parse my Google Sheets master spreadsheet to match that serial number with my records regarding that particular serial number.
3. Pull these records from the Google Sheets spreadsheet about that product and present the information on the page.

Example:

1. Customer has product serialized 123456 and enters this number into SquareSpace form on my page.
2. Serial #123456 is found in A17 in my Google Sheet and has additional data associated in B17:E17.
3. Webpage presents data from Google Sheet B17:E17.

The intent to to serve as a digital replacement for the serialized warranty cards that I include with my product.

I don't have much HTML experience and have tried looking into Zapier, AppSheet, and the Google Sheets API for clues into my next steps.

Can someone get me on the right path to get this built?

Thanks!

2 hours ago, zackwok said:

Hello everyone!

I am trying to build a webpage on my SquareSpace site that will:

1. Prompt my customers to enter the serial number for a product that they bought from my shop into a form.
2. Parse my Google Sheets master spreadsheet to match that serial number with my records regarding that particular serial number.
3. Pull these records from the Google Sheets spreadsheet about that product and present the information on the page.

Example:

1. Customer has product serialized 123456 and enters this number into SquareSpace form on my page.
2. Serial #123456 is found in A17 in my Google Sheet and has additional data associated in B17:E17.
3. Webpage presents data from Google Sheet B17:E17.

The intent to to serve as a digital replacement for the serialized warranty cards that I include with my product.

I don't have much HTML experience and have tried looking into Zapier, AppSheet, and the Google Sheets API for clues into my next steps.

Can someone get me on the right path to get this built?

Thanks!

You can publish the spreadsheet as CSV or HTML into a url and parse this content using javascript to filter and display the matched info into your frontend