FeedOtter Logo Standard

Help & Support

Written by
Catie Hammond

How to Use Google Sheets Data in Curated Newsletter Creation

Published on
June 7, 2021

FeedOtter allows you to integrate your Google Sheets as content source in our Curated Newsletter section. Now, you can easily put your Google Sheets data in Curated Newsletters by dragging and dropping directly into FeedOtter. Here, we'll walk through integrating your Google Sheets for Curated Newsletter content.

Google Sheets Data in Curated Newsletters

Here's the full video tutorial for using Google Sheets data in curated newsletters, or you can follow the step-by-step guide below.

Create Google Sheet for Integration

When creating your Google Sheet list of content, you'll need to ensure you have basic fields of information including Title, URL, and Description. You'll also need the Image URL if you're adding images to your newsletter.

Create these fields in your Google Sheet and start listing your content accordingly.

Google sheets data in curated newsletter

Once integrated with FeedOtter, this content will be listed and ready for drag-and-drop use in your Curated Newsletter.

Select Google Sheets ID

Next, find your Google Sheets ID. This will allow FeedOtter to read your Google Sheets data and pull it into your curated newsletter.

In the URL box of the sheet, select the long string of letters and numbers and copy. This is your Google Sheets ID.

Google Sheets ID to put google sheets data in curated newsletter

Add to Content Sources

Open a new tab and go to your FeedOtter account.

Here, click the Gear icon in the top right corner and go to Settings.

Click Content Sources Add New Content Source.

Here, you'll integrate your Google Sheets data of content.

Integrating Google Sheets data in curated newsletters sources

First, select your Content Source Type as Google Sheet, then name your content source and paste in the Google Sheet ID.

Click Lookup. Now, you can choose the sheet you want and map up the content fields to FeedOtter.

Once you've aligned your content in the Google Sheet with FeedOtter's content blocks, click Save.

Integrating your Google sheets data in curated newsletters for FeedOtter

Create A Curated Newsletter Issue

Your Google Sheets data is connected to FeedOtter and ready to go. Now, create your Curated Newsletter and open a new issue.

Add Your Google Sheets Data in Curated Newsletter

Under the Content tab, click Add Content. Here, you'll see the newly added Google Sheet. Select it, and see your content available for choosing.

Google Sheets to newsletter in FeedOtter Curated Builder

Here, you can drag, drop and reorder content to look they way you want in your newsletter. You can also edit each content block, just like you would with an RSS feed or the Content Queue Bookmark content.

NOTE: If you edit any of the content directly in FeedOtter, this will NOT update or change the content in your Google Sheet. However, if you edit content in Google Sheets, you can refresh your FeedOtter page and see those changes reflected in FeedOtter.

BONUS: Adding Custom Fields to Your Content

FeedOtter also allows you to add custom Google Sheets data in Curated Newsletters with a little bit of HTML coding. You can add any custom fields you want, including date, author, subheadings and more.

To do this, first create the custom field in your Google Sheet and add your content for each content block. Then, you'll need this token to add to your Curated Newsletter.

[[post.asArray.Custom1]]

Replace Custom1 with the name of your custom field in Google Sheets.

Next, go to your Curated Newsletter issue in FeedOtter and select View Code.

Decide where you're adding your custom field.

For example, if adding an author field directly below the title, find the title token in the code and add your token below the </p> tag.

Custom google sheets data in curated newsletter

Paste this code exactly (renaming your custom field accordingly):

<p> [[post.asArray.Custom1]] </p>

Click Save.

Here, you'll see your custom field added to your content blocks in FeedOtter.

custom field from google sheets data in curated newsletter

Happy Emailing!

That's it! You've successfully integrated your Google Sheets with FeedOtter for content curated newsletters. If you have any questions or are having any issues, feel free to email us at success@feedotter.com.