How to get Squarespace orders into Zapier

If you’ve ever needed to connect your Squarespace orders to Zapier for streamlined workflows, I’ve got good news: it’s easier than you think. Recently, I had to figure this out for myself because I’m selling an eBook as a physical product variant on Squarespace. The catch? I needed a way to make sure my eBook customers got their purchase delivered to their email inbox automatically.

Here’s how I solved it—and how you can, too.

The Problem: Automating eBook Delivery

In my case, I’m selling a physical product with one variant being an eBook. While Squarespace handles physical product orders just fine, it doesn’t natively handle automated eBook delivery. To make it work, I needed to export orders and integrate them with Zapier, where I could set up an email workflow for eBook customers.

The Solution: SuperJack

This is where SuperJack came in and saved the day. SuperJack is a tool that lets you automatically export all your Squarespace orders into a Google Sheet in real time. Once the data is in Google Sheets, you can easily integrate it with Zapier and use it however you need—whether that’s sending emails, updating records, or triggering other workflows.

Step-by-Step: Setting Up the Workflow

Here’s how I got it done:

1. Connect SuperJack to Squarespace and Google Sheets
   After signing up for SuperJack (which gives you a free 3-day trial), the first step is connecting your Squarespace account. It literally takes five seconds. Then, connect your Google Sheets account—another five seconds.

2. Export Orders to Google Sheets
   SuperJack allows you to choose which fields you want to export or even narrow it down to specific products. This feature is a lifesaver if you’re dealing with multiple product types and want to keep things clean in your spreadsheet.

3. Filter Data in Zapier
   Once orders start exporting to Google Sheets, you can set up Zapier to filter out only the eBook orders. Zapier then sends an email to those customers with their eBook attached or a download link.

   • Example: “Hey, here’s your eBook!”

   • This workflow pulls customer data from the Google Sheet, filters it based on the product purchased, and triggers the email.

4. Toggle Zapier Compatibility
   SuperJack includes a handy toggle for Zapier compatibility, ensuring your Google Sheet is ready to integrate seamlessly. Just make sure to enable the New Spreadsheet Row Team Drive option, and you’re good to go.

Why SuperJack is a Game-Changer

I was blown away by how quick and easy this setup was. From start to finish, I had my workflow running in just minutes. No complicated coding, no manual exports—just a smooth, automated system that worked on the first try.

Whether you’re delivering eBooks, triggering notifications, or syncing orders with your CRM, SuperJack simplifies everything. Plus, it’s flexible enough to handle just about any Zapier integration you can dream up.

Try It Yourself

If you’re ready to automate your Squarespace orders and streamline your workflows, check out SuperJack. You’ll be up and running in no time. Let me know if you have any questions—drop them in the comments, and I’ll do my best to help.

Peace.

How to Offer Both Digital and Physical Variants of the Same Product on Squarespace

Are you trying to sell both physical books and their digital versions on your Squarespace site but feeling stuck?

I know exactly how you feel - I faced the same problem trying to sell my ebook and paperback in the same product listing.

Like many Squarespace users, I quickly realized the platform doesn't natively support selling digital variants alongside physical products without creating a mess. To offer both options, I was forced to either clutter my shop with duplicate listings or manually send digital files after every sale. Neither felt professional, scalable, or sustainable.

The suggested "workaround" of creating separate product entries for each format left my shop feeling disorganized and overwhelmed my customers with too many choices. For someone managing multiple products, this quickly became an administrative nightmare.

I wanted a way to offer my customers the choice between a physical book and an eBook in one clean, seamless product listing—without leaving the Squarespace ecosystem or spending hours fixing it every time I made a sale.

In this post, I’ll share the solution I discovered: a custom JavaScript workaround that dynamically customizes the order confirmation page. With this approach, your customers can download their eBook immediately after purchase, while your shop stays organized, user-friendly, and professional.

ebook variant order page

physical variant order page

Setting Up Variants for Digital and Physical Products in Squarespace

The key to keeping your shop organized while offering both digital and physical versions of the same product is using variants. Variants let you provide different options—like “eBook” and “Paperback”—under the same product listing, creating a clean and streamlined shopping experience.

Here’s how to configure and handle variants effectively:

1. Add Variants to Your Product

• Edit Your Product: Go to the Squarespace dashboard, navigate to Commerce > Inventory, and select the product you want to modify.

• Enable Variants: Under the Pricing & Variants tab, click Add Variant.

  • Create an option called Format (or something similar) to represent the type of product.

  • Add options like Paperback and eBook.

• Set Pricing: Assign different prices to each variant if needed. For example, the Paperback might cost $15, while the eBook is $7.

2. Use Custom JavaScript to Handle Digital Variants

Squarespace doesn’t natively deliver files for digital product variants, so we’ll use JavaScript to detect when the eBook variant is purchased and display a download link on the order confirmation page.

Here’s how to implement it:

Code to Inject:

1. Navigate to Settings > Advanced > Code Injection.

2. Scroll to the Order Status Page section.

3. Add this JavaScript:

<script>
document.addEventListener('DOMContentLoaded', function() {
    // Search for all spans to find if any contain 'Format: eBook'
    var allSpans = document.querySelectorAll('span');
    var ebookFound = Array.from(allSpans).some(span => span.textContent.includes('Format: eBook'));

    if (ebookFound) {
        // Target the tracking updates section and change the heading
        var trackingSections = document.querySelectorAll('h2');
        var trackingSection = Array.from(trackingSections).find(section => section.textContent.includes('Tracking updates'));

        if (trackingSection) {
            // Update the heading text
            trackingSection.textContent = 'Download Your eBook';

            // Find the parent container that holds the content to be replaced
            var contentContainer = trackingSection.nextElementSibling;
            if (contentContainer) {
                // Replace with a button that matches the Squarespace style
                contentContainer.innerHTML = `<center><button aria-label="Download eBook" width="100%" class="css-12it2aq"><a href="https://www.omariharebin.com/s/The-Corporate-Dropout-A-Memoir.zip" style="color: inherit; text-decoration: none;">Download the eBook here</a></button></center>`;
            }
        }

        // Optionally, hide shipping information
        var shippingInfo = document.querySelector('.shipping-info'); // Adjust this selector based on your actual shipping info container
        if (shippingInfo) {
            shippingInfo.style.display = 'none';
        }
    }
});
</script>

What the Code Does:

• Detects the eBook Variant:

  • The script searches for spans on the order confirmation page that include the text "Format: eBook."

• Customizes the Order Confirmation Page:

  • If the eBook variant is found, the script updates the heading “Tracking updates” to “Download Your eBook.”

  • It replaces the section content with a download button styled like Squarespace’s default buttons.

• Hides Shipping Information:

  • For digital purchases, unnecessary shipping information is hidden for a cleaner user experience.

3. Testing Your Setup

• Perform test purchases for both digital and physical variants:

  • For eBooks: Verify that the download button replaces the tracking section and functions correctly.

  • For Physical Products: Confirm that the order confirmation page remains unchanged.

• Test across multiple devices and browsers to ensure compatibility.

4. Optional Enhancements

• Add analytics tracking to measure how often the eBook link is clicked.

• Style the download button further using CSS to better match your brand’s aesthetic.

Conclusion

By following this tutorial, you’ve not only simplified your Squarespace shop but also solved a long-standing issue for store owners selling digital and physical products. With just a few tweaks, your customers can easily choose their preferred format, and you can automate digital file delivery—all while keeping your shop neat and professional.

Advanced Customization: Handling Multiple Digital Variants or Non-eBook Products

While this guide focuses on selling eBooks as a digital variant, the same solution can be easily adapted for other types of digital products or even multiple digital variants like licenses or formats.

Adapting for Non-eBook Digital Products

If you’re selling other digital products—like audio files, videos, or software—you can tweak the script to detect specific product types and provide the appropriate download links. For example:

• Music Files: Offer both MP3 and WAV formats with unique download links.

• Licenses: Provide Personal Use and Commercial Use license options for the same product.

• Training Materials: Allow customers to choose between Basic and Advanced course content.

How It Works

1. Detect the Variant: Adjust the JavaScript to look for specific text in the product variant (e.g., "Format: MP3" or "License: Personal Use").

2. Match the Download Link: Use conditional logic or a variant-to-URL mapping to provide the correct file for each digital product.

Example Script

Here’s a dynamic version of the script that supports multiple digital variants:

<script>document.addEventListener('DOMContentLoaded', function() {
    // Variant-to-URL mapping
    var variantLinks = {
        'Format: MP3': '/s/Your-MP3-File.zip',
        'Format: WAV': '/s/Your-WAV-File.zip',
        'License: Personal Use': '/s/Personal-License.zip',
        'License: Commercial Use': '/s/Commercial-License.zip'
    };

    // Detect the variant
    var allSpans = document.querySelectorAll('span');
    var matchedVariant = Array.from(allSpans).find(span => variantLinks[span.textContent.trim()]);

    if (matchedVariant) {
        var downloadUrl = variantLinks[matchedVariant.textContent.trim()];

        // Update the confirmation page
        var trackingSections = document.querySelectorAll('h2');
        var trackingSection = Array.from(trackingSections).find(section => section.textContent.includes('Tracking updates'));

        if (trackingSection) {
            trackingSection.textContent = 'Download Your File';
            var contentContainer = trackingSection.nextElementSibling;
            if (contentContainer) {
                contentContainer.innerHTML = `<center><button aria-label="Download File" class="css-12it2aq">
                    <a href="${downloadUrl}" style="color: inherit; text-decoration: none;">Download the File Here</a>
                </button></center>`;
            }
        }

        // Optionally hide shipping info
        var shippingInfo = document.querySelector('.shipping-info');
        if (shippingInfo) {
            shippingInfo.style.display = 'none';
        }
    }
});
</script>

Why This Matters

This approach is scalable and adaptable:

• Works for any type of digital product or multiple digital variants.

• Reduces manual effort by automating the delivery of the correct file for each purchase.

• Keeps the order confirmation page clean and user-friendly.

Use Cases

• Audio Products: Variants like MP3 and WAV link to separate files.

• Digital Licenses: Provide different license options (Personal, Commercial) for the same digital asset.

• Digital Art or Stock Photos: Variants like Web Resolution and High Resolution deliver appropriate file sizes.

Next Steps

So while this solves the checkout page problem, we still need to get the ebook download link via email.

That’s where SuperJack + Zapier come in.

How to set Squarespace Portfolio project as Draft

This post is a collaboration with BeyondSpace.studio

Squarespace Portfolio is an incredible tool for showcasing your creative work, but there’s one glaring limitation: there’s no built-in draft mode for Portfolio projects. This can be frustrating if you want to hide unfinished projects from public view while still working on them.

For creators and businesses, maintaining a polished and professional portfolio is crucial. Without a draft mode, you’re left with limited options to keep incomplete work under wraps. But don’t worry—there’s a solution! Draftify Portfolio from Beyondspace offers a simple way to manage your portfolio drafts and ensure only finalized projects are visible.

Introducing Draftify Portfolio

Draftify Portfolio enables you to hide Portfolio items while you edit, ensuring they don’t appear on your live site until they’re ready. Say goodbye to awkward half-finished projects cluttering your professional portfolio.

Here’s how you can take control of your Portfolio with ease:

Step-by-step tutorial

Step 1: Install Ground Control

Draftify Portfolio is available through the Ground Control plugin. Install it to unlock the ability to manage draft and published states for your Portfolio projects.

Step 2: Create and Manage Portfolio Items

After installing Ground Control, follow these steps:

1. Create a new Portfolio project as usual.

2. Click the three-dot menu icon next to your project in the Portfolio manager.

3. Use the new options:

   • Set as Draft: Hides the Portfolio project from public view.

   • Set as Published: Makes the project live and visible.

Turn Portfolio project to draft

Draft vs. Published Portfolio Projects

Draft Mode:

• Portfolio items are hidden from visitors.

• Draft items won’t appear in Portfolio collection pages, including Grid or Hover layouts.

• Draft items will be hidden from Portfolio page’s pagination, next published projects will be displayed instead

• URLs for draft items will return a 404 page if accessed.

Published Mode:

• Projects are fully visible on your site.

• Accessible through their URLs and appear in all Portfolio collection displays.

Redirecting 404 Pages for Drafted Items

To maintain a seamless user experience, redirect the URLs of drafted projects to your main Portfolio page. Here’s how:

1. Navigate to Settings > Developer Tools > URL Mappings in Squarespace.

2. Add the following line, replacing your-portfolio with your Portfolio’s actual slug:

/your-portfolio/[name] -> /your-portfolio 302

This ensures visitors attempting to access a drafted project are redirected to the main Portfolio page instead of encountering a 404 error — especially useful when you’re editing an indexed project.

Conclusion

Using the Ground Control plugin simplifies managing your Squarespace portfolio by allowing you to set projects as drafts easily. This feature is particularly useful for creatives who want to work on projects privately before showcasing them publicly. For additional details, refer to resources such as the Draftify Portfolio for comprehensive instructions and support