fbpx

How to add a SendGrid Contact with Zapier Code Snippets

If you’re trying to connect a Squarespace newsletter signup form to SendGrid, this is the article for you.

Recently, I needed to connect a Squarespace newsletter form to SendGrid. There’s not a direct integration, so using Zapier to store the Squarespace newsletter signups in SendGrid was the best option.

I spent a while googling for “how to connect Squarespace to SendGrid”. It was easy to learn how to send an email after someone signed up; however, annoyingly SendGrid did not automatically add this person to my contacts database.

If you’re trying to figure out how to use Zapier’s code snippets to add a contact to SendGrid using the API endpoints, then this should help!

Here’s the final code snippet used in Zapier. (Note: You’ll need to add your own SendGrid API Key.)

const data = {
  "list_ids": [
    "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx" // LIST_ID
  ],
  "contacts": [
    {
      "email": inputData.email,
      "first_name": inputData.firstName,
      "last_name": inputData.lastName
    }
  ]
}

const res = await fetch('https://api.sendgrid.com/v3/marketing/contacts', {
  method: 'PUT',
  headers: {
    'Content-Type': 'application/json',
    'authorization': 'Bearer SG.xxxxxxxxxx' // SENDGRID_API_KEY
  },
  body: JSON.stringify(data),
})
.then(response => response.json())
.then(data => {
  console.log('Success:', data);
})
.catch((error) => {
  console.error('Error:', error);
});

return { res: res };

Despite a rather popular Github issue discussing the difficulties in shaping the request, there’s surprisingly little information on this. This is partially because SendGrid supports a legacy API that uses a different endpoint, api.sendgrid.com/v3/contactdb/recipients/.

I’ll also point out that the inputData object is injected by Zapier. You can choose a variable from a previous step in your Zap to inject with whatever variable name you decide.

Lastly, make sure you ensure your Zap is turned on! Annoyingly, Zapier seems to turn the Zap off anytime the code produces an error. This is problematic if you have previous steps that you want to function while trying to test the code snippet. In my case, this meant newsletter signups were not receiving the welcome email because the Zap was automatically turned off and I didn’t realize it!

You can see the “On” toggle in the top-right below.

I hope this helps you store your Squarespace newsletter signups in SendGrid!


Note: I believe that API access requires a paid SendGrid account, so you may run into unforeseen issues if you’re trying to do this on the free account.

Announcing summerof.design – A 6-Week UX Portfolio Challenge

summerof.design is a 6-week challenge to create & improve a competitive portfolio that wins over hiring managers, gets you the interviews, and secures the job offer.

Melody and I have been collaborating on various projects for the past 3 years. Prior to that, we worked together (and met) on Coursera’s design team. Today, we’re excited to launch Summer of Design.

In the past year, multiple aspiring UX professionals reached out to us for mentorship and assistance. Through these conversations, we saw the gaps in professional development unmet by undergraduate degrees, self-study programs, and bootcamps.

While there are many listicles out there about the “10 Must Have XYZ to Break Into UX Design” – our hope is that you won’t ever need to read one of those again. 6 weeks, 3 core projects, and a bunch of tactical, no-nonsense tips & strategy to actually get your first job as a UX/UI/Product Designer.

Collectively, we’re combining 15+ years of experience working at places like Palantir, Twitter, and Nextdoor. We’ve played pivotal roles launching major products at Brex, Coursera, multiple Y Combinator startups, and more. We’re excited to share what we’ve learned with you, or folks in your network.

Apply by July 3rd

9 Black-Owned Bay Area Businesses to Order From Online

Face masks, jewelry, tea and more to buy now

It’s never been more important to support Black-owned businesses. As we now are buying more of our products online to keep life moving while indoors during the pandemic, every click of the “checkout” button is an opportunity to support local black-owned businesses in the Bay Area.

If you don’t need or want anything for yourself, why not support your Black friends, family or colleagues—assemble a care package of candles, lotions, tea, and more from the list of businesses below, support black entrepreneurs in the process, and show them some love.

Ready to do more? Consider donating to black activists & thought leaders or move your money into Black-owned banks. Every swipe of our credit card is a chance to show up for our Black friends, family, neighbors, and colleagues today and every day.

???? Health & Wellness

Beija-Flor Naturals

Stevonne Ratliff founded Beija-Flor Naturals in 2013 in Oaklandwhen she opened the first brick-and-mortar store, Concept Forty-Seven. Disappointed with the lack of natural skincare solutions — particularly for women of color — she took matters into her own hands. Products are crafted with fair trade, nutrient-rich botanical ingredients from Brazil, which also inspired the brand.

Goddess Butter

Specializing in restorative body and hair butter, Goddess Butter was born out of Jazz Monique Hudson’s background in healing and a request by her partner to sooth eczema. Based in Oakland, the butters come in four types ranging from invigorating lemongrass and lavender to soothing cocoa and shea.

Anasa Yoga

Jean Marie Moore and Katrina Lashea founded Anasa Yoga to bring yoga and wellness practice to the Laurel District in the heart of Oakland. They offer a wide variety of virtual practices including Vinyasa Flow, Restorative, Kundalini, Prenatal, and more. The studio is currently offering a wide array of online classes. 

Source: https://www.anasaoakland.com/

???? General & Books

Ashay By the Bay

This beloved local bookstore has thee largest independent online selection of African American and multi-cultural children’s books available.. Founder and CEO Deborah Da, opened Ashay by the Bay in 2000 before moving online in 2002. They’re based in Vallejo, CA.

Big Chop Accessories

Christian Joy founded Big Chop Accessories, a boutique and nail salon in the East Bay,to create and accentuate women’s self-style, inspiring women around the Bay Area with unique textures, prints, and styles. The store is selling a wide variety of clothing items online.

???? Fashion and Art

Taylor Jay Collection

Founded by (you guessed it!) Taylor Jay, this collection is built on the value of inclusivity. Jay, a Bay Area native, has grown a set of styles that embrace different body types, use high-quality materials, and elevate the concept of comfort. They also have face masks available for purchase now.

Candid Art

Candid Art was established by Oakland native Candice Cox, a self-taught jewelry designer and graduate of the Howard University School of Business. Candid Art ethically sources textiles from African vendors, uses natural dyes, and employs sustainable organic production processes to create handcrafted pieces that make a statement. I bought one of their masks for a friend of mine and it was really high-quality.

???? Food

Peaches Patties

Peaches Patties is a Jamaican catering company based in San Francisco. Founded by Executive Chef Shani Jones, the business is one of a few Caribbean food outlets in SF and focuses on combining fresh ingredients, flavorful spices, and authentic Jamaican cuisine.

Hella Tea

Chantrelle Edwards is an Oakland native who founded Hella Tea to offer an exceptional tea experience that combines her appreciation of Hip-Hop culture and love of Oakland. They offer a wide variety of flavorful, creatively-named teas like “Chamo-LA Harris” and “E-4Tea”, which many Bay Area natives will appreciate.

How to Land Your First Few Clients Freelancing

When people know I freelance and run Studio Flurry, the first question is always the same: “How do you find your clients?” The simple answer is hustle. The tactical answer is detailed below.

1. Tell people you’re freelancing

Surprisingly, most people don’t do this. Just waiting for folks to knock on your digital door isn’t going to work. Taking tactical steps that strategically inform your network will.

  • Post on your social media channels, including LinkedIn.
  • Message every one of your LinkedIn contacts in your industry and tell them you’re freelancing. (Seriously, this is huge!)
  • Visit contacts.google.com and export your 100 frequent contacts. Email them to let them know you’re freelancing.

This can take up to 2 weeks depending how fast you move. Let them know you’re now freelancing full-time and spending some time letting your network know. Ask if they know anyone looking for your skillset.

2. Set an achievable & specific goal

When I first started freelancing, I focused on an achievable goal: make enough to cover my rent each month. I ended up making more, but this helped me hit an initial milestone quickly.

Set a goal that’s achievable for you. Avoid pie-in-the-sky goals and do something near-term. You want to get feedback quickly. Honestly, I think a goal to cover your monthly costs of living is a great starting point.

After you hit that, you can set a new goal for savings, retirement, or other things.

3. Learn a little about “business”, sales, & negotiation

You don’t need to read every book, or even all of a book. The goal is to understand some basics so you can communicate prices confidently and clearly.

Confusion and doubt over how much you charge, when you bill, and whether you can deliver will make it hard to land projects. Don’t “just wing it”.

If a client asks you for cost-related info, be prepared to offer a competitive hourly rate or a clear framework for them to understand how cost is calculated. If you have absolutely no sense of a reasonable hourly rate, then start with a tool like this freelance rate explorer aggregated from real data.


Good luck! If you want some personalized coaching and strategy for your freelance/agency ambitions, I offer a few 1-hour sessions the first Friday of most months. Reach out at hello@joelaguero.com for availability.

8 Memorable Moments from Season 1 of Avatar: The Last Airbender (Now on Netflix!)

Technically this includes some light spoilers for Season 1. If you aren’t familiar with the series, I’d recommend watching it first. You won’t regret it!

If you’ve ever come across a fan of Nickelodeon’s Avatar: The Last Airbender, then you might have felt surprised. How could a children’s show be so popular? Over the years, the show’s stood out because it’s staying power crystalized.

In the show, lovable, flawed, and multi-dimensional characters grapple with personal transformations that parallel a broader transformation in the world. Aang, the Avatar, must restore peace and balance in a world caught in conflict.

I just started re-watching it and catalogued some of my favorite aspects of the first half of Season 1. Below are 8 memorable moments you can re-live now that the entire series is on Netflix. I’d love to know any not feature that you particularly love.

1. Appreciating the true terribleness of The Great Divide – one of the only real filler episodes in the series – given how amazing the show is overall.

2. When Uncle Iroh captures the way Aang not only represents hope to the world, but represents hope to his nephew, Prince Zuko, too.

3. Uncle Iroh’s infinite wisdom, cheesy humor, and early references to the Order of the White Lotus.

4. Katara before she goes through one of the greatest glow-ups of all time.

5. When the first episode addresses the double-standards women face head-on.

6. The first appearance of the Kyoshi Warriors, when Soka spends an entire episode in “Battle Drag” and unpacks his biases against women.

7. The satisfaction felt when Aang becomes Avatar Roku; the accompanying fear on the faces of the corrupted Fire Temple Sages.

As the top-voted comment says: “The quality we don’t want, but the video we need.”

If you’re also re-watching the series now that it’s on Netflix, let me know some of your favorite other moments!