How to Add a Google Sheet to Squarespace

If you own a Squarespace website and want to display a Google Sheet on it, this article will guide you through the process. Follow these simple steps to integrate your Google Sheet into your Squarespace site:

Share your Google Sheet

1. Open the Google Sheet that you want to integrate into your website.
2. Click on the “Share” button on the top right corner.
3. Choose the “Anyone with the link” option.
4. Click “Done”.

By default, your first sheet (tab) will be used. If you want to add another sheet, simply drag it to the left to place it in the first position.

Create an Embed Code

1. Copy the code below:

<!-- Insert your embed code here -->

Paste the Embed Code on a Squarespace Page

Squarespace has a great feature called “Code Block” that allows you to add custom HTML and JavaScript code snippets to your site. Here’s how to use it:

1. Open your Squarespace site in edit mode.
2. Create or select a page where you want to add your Google Sheet.
3. Click on “Insert Point”.
4. Select “Code”.
5. Open the code editor.
6. Paste the embed code into the code area.
7. Make sure the “Show Source” option is disabled and the mode is set to HTML.
8. Click “Apply”.

Publish your Squarespace page

You will only see your integrated sheet after publishing your Squarespace site. Make sure to publish your site and this specific page by following these steps:

1. Go to “Settings”.
2. Click on “Site Availability”.
3. Select “Public”.

Now your Squarespace page will display a Google Sheet table. Your Squarespace page elements such as the navigation bar, logo, footer, etc. will remain the same, but you will see a table like this inside the page:

For more tips and tricks on Google Sheets, visit Crawlan.com.