Braze tip #4: Create a Google Sheet API account

updated on 12 June 2023

This is part #1 of one of our most used self taught hacks which consists of using Braze's Connected Content to read from Google Spreadsheet.

Part 1: Set up your Google API Credentials in order to automate your Braze messaging by reading your content directly from a Google Spreadsheet!

Isn’t it time consuming to set up campaigns directly on Braze platforms and having to go through all the campaigns set up in order to change the message?

With this solution, you’ll be able to read your messages directly from a spreadsheet and save tons of time.

image-9cfz5

Set up your Google API Credentials

We will need a Google developers account. You can go here and create one, it’s free.

Let’s create a new project:

image-ne2s8

Edit your project’s name and hit create:

image-7ex8x

Next, let’s generate credentials for the project. We’ll need these API keys in order to access Google services. We will only read tables, so by just generating API keys it’ll be enough

image-cyr1z

Search and select Google Sheets API:

image-6u04d

Hit Enable:

image-a7se0

Finally, click on “create credentials” and API Key. If your data is sensitive you might want to set up a 0Auth credentials

image-t83hp

Copy your API Key (and don’t share it). Now you’ve finished your set up!

image-8ulau

Awesome! You’ve already set up your Google API Credentials!

Read part #2 on how to use Connected Content to read from Google Spreadsheet and automate all your content creation.

Read more

Runs on Unicorn Platform