Developing a content marketing strategy for your business can help you reach new customers you may not otherwise reach with traditional marketing. Putting together an impactful content pipeline requires more than just drafting a few articles. Between researching topics, identifying keywords with a high SEO value, coordinating work between writers and editors, and putting everything together in a CMS system, content marketing often requires a lot of resources.
Managing your pipeline in Spreadsheet.com can alleviate some of this work. With powerful features like Related Rows, no-code automations, and integration with OpenAI, Spreadsheet.com is the perfect tool to help you execute a content marketing strategy in a faster and more resource-efficient way.
Read on to learn how you can use Spreadsheet.com to manage any content marketing campaign.
Once you decide on a list of topics to build your content pipeline around, you need a list of SEO-optimized keywords to include throughout your content. Instead of researching and creating these lists on your own, use Spreadsheet.com’s OPENAI_COMPLETE function to ask OpenAI to handle the work for you.
Above, in Column B, we’re asking OpenAI to generate a list of ten keywords for each topic listed in our worksheet. Part of our OpenAI request asks that those keywords have a high SEO value to make sure our content is optimized for search engines.
Try adjusting your OpenAI query to change the number of keywords returned, or to receive keywords optimized for a specific platform like LinkedIn or Twitter.
With article topics and target keywords under your belt, the next step in building your content pipeline is to plan a list of articles to be featured on your blog or website. In our workbook, we’ve created a list of topics in one worksheet and a list of articles in another. With the Related Row data type, we can link these records together so that our worksheets act like tables in a relational database.
In the “Content Topics” worksheet, each topic lists all of the associated articles in Column C. In the “Articles” worksheet each article lists the associated topic in Column E. Click on any related row value to open the expanded row from the linked worksheet.
Using Related Rows enables other data types like Related Row Lookups, which return specific information from linked rows, and Related Row Rollups, which return aggregate calculations from linked rows.
Spreadsheet.com’s 25+ rich Data Types let you collect all types of data in your workbooks, from dropdown Select lists to icon sets and visual rating systems. One of the most popular and powerful of these is the Attachment data type, which lets you store files in worksheet cells.
In our workbook, we’re using the Attachment data type in Column C to store the hero image for each of our articles. Any writer or editor with access to this workbook can download the attached file and upload it to a CMS system. Attachment cells can hold one or multiple attachments, and you can click on a thumbnail to view the attachment in full size.
Along with keywords and article titles, meta descriptions play an important role in optimizing your content pipeline for SEO. And just like your keyword lists, you can ask OpenAI to generate these descriptions for you.
In our workbook, we’re giving OpenAI an article title and asking it to return an SEO-optimized meta description. Many CMS systems impose a character limit on these descriptions, which your OpenAI request can accommodate.
We’ve asked OpenAI to limit its responses to 400 characters, but you can modify your request to meet any restrictions you encounter. Try fine-tuning your OpenAI queries by asking it to generate meta descriptions based off of a title and keywords, or reference a part of your completed article and ask for a meta description based off of that instead.
Spreadsheet.com’s native no-code automations let you automate repetitive tasks and integrate your workbooks with other work tools like Slack and Microsoft Teams. Automations can be triggered by things that happen in your workbooks – like columns being updated – or can be time-based.
Time-based automations are a great way to remind writers and editors about upcoming deadlines automatically.
In our workbook, we’ve created an automation that sends a Slack message to our team the day before a draft’s due date, listed in Column F of our “Articles” worksheet.
You can create different automations by mixing and matching different triggers and actions. Try creating automations to…
Spreadsheet.com also integrates with Zapier, allowing you to integrate your workbooks with thousands of other popular work applications.
Ready to use Spreadsheet.com to help manage your content marketing pipeline? Get started for free today. Check out our Template Gallery to get a head start on your workbooks, or begin creating your own from scratch.
For more information on the features seen in this guide, visit our Help Center.