# Google Sheets FeedOtter allows you to easily drag and drop content from a Google Sheet into your email newsletters via our Content Source integration. Here are the steps to setup your first Google Sheet content source. ### Google Authorization The first step is to create a new Integration in FeedOtter for your Google account. This step only needs to be done once for each Google Drive resource you need to access. 1. In FeedOtter, navigate to Settings > Integration 2. Click **Add integration** 3. Customize the name of your Google connection (optional) 4. Follow the on-screen steps to authorize your Google Account 5. Click **Allow** to give FeedOtter permission to connect your Google Sheet spreadsheets. {% hint style="info" %} If you see a warning from Google, please click the "Continue Anyway" button. This message may appear from time to time as Google reviews our integration. {% endhint %} #### After completing the setup you will be returned to FeedOtter's Integration table. Click the TEST button next to your new Integration and ensure it lights up green. ### Create A Content Source #### To create a new content source from a Google Sheet. 1. In FeedOtter, navigate to Settings > Content Sources 2. Click **New Content Source** 3. Select Google Sheet 4. Give your Content Source a memorable name 5. Under Google Connection, select the Google connection related to the Sheet you want to access. 6. Next we need to find and input the unique id of our Google Sheet. To do this open your Google Sheet. In the URL box of the sheet, select the long string of letters and numbers and **copy.** This is your Google Sheets ID.

Open your Google Sheet and copy the id string as shown above into the FeedOtter UI.

7. Click Lookup. 8. If your settings are correct FeedOtter will present dropdowns that allow you to select the Sheet > Worksheet (tab) you wish to access and map up the basic Title, Description, Date, and URL fields. {% hint style="info" %} If you wish to access addl. data from your Google sheet please open a ticket with our support team for assistance. Data beyond the standard fields can be accessed using the \[\[post.asArray.columnName.value]] token paradigm. Replace the word "columnName" with the actual name of your Sheet column. (case-sensitive) {% endhint %} 9. Click Save, and then the TEST button to ensure everything is working. 10. You will now be able to view data from your Google Sheet when adding Available Content in Curated Newsletters. ### What Makes a Good Google Sheet Content Source? 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.

Data should be laid out with a heading in row 1 and data organized into simple columns and rows.

### Accessing your Google Sheet data in FeedOtter Google Sheet data is accessed when building [Curated Newsletters](/curated-newsletters/getting-started.md). #### To start using your Google Sheet data in a newsletter Create a new Curated Newsletter Issue, or edit and existing one. 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](https://www.feedotter.com/wp-content/uploads/2021/06/google-sheets-newsletter.png) 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](https://www.feedotter.com/articles/how-to-bookmark-a-page-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. ### Accessing non-standard Sheet data in your email FeedOtter allows you to add custom Google Sheets data in Curated Newsletters with a little bit of HTML coding. In our spreadsheet we already created a column named Custom1. Here is how to add that data into our HTML email code.
For custom data we will add tokens that look like this: ``` [[post.asArray.Custom1]] //replace "Custom1" with your exact column name. ``` {% hint style="warning" %} You will need to edit your HTML email's code, this part assumes you know how to do this. {% endhint %}
On line 584, we pasted in the appropriate token. Save your code changes and you should see the custom data appear in your email preview. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.feedotter.com/curated-newsletters/content-sources/google-sheets.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.