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.
Here’s the full video tutorial for using Google Sheets data in curated newsletters, or you can follow the step-by-step guide below.
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.
Once integrated with FeedOtter, this content will be listed and ready for drag-and-drop use in your Curated Newsletter.
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.
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.
First, select your Content Source Type as Google Sheet, then name your content source and click Save.
Here, you’ll be taken to Google’s authorization page. Sign in to your Google account.
Next you’ll see a popup saying “Google hasn’t verified this app.” No worries! Your information is safe and we only access Google Sheets that you’ve given us permission to access.
Click the Advanced option in the bottom right corner. Then, select Go to feedotter.com.
Continue through Google’s access pages until you’ve been sent back to FeedOtter. Now, 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.
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.
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.
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.
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.
Paste this code exactly (renaming your custom field accordingly):
<p> [[post.asArray.Custom1]] </p>
Here, you’ll see your custom field added to your content blocks in FeedOtter.
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 [email protected].