We want an up-to-date list of blog URLs for AI to be able to reference your content when making post recommendations
https://gokickflip.com/robots.txthttps://gokickflip.com/sitemap.xmlhttps://gokickflip.com/sitemap_index.xmlhttps://gokickflip.com/blog-sitemap.xmlhttps://gokickflip.com/blog/sitemap.xml<head> of the homepage; sometimes there’s a <link rel="sitemap" …> or canonical reference.In your Google Sheet:
function getYourBlogUrls() {
var sitemapUrl = "[PASTE YOUR SITEMAP URL]";
var response = UrlFetchApp.fetch(sitemapUrl, {muteHttpExceptions: true});
var xml = XmlService.parse(response.getContentText());
var root = xml.getRootElement();
var ns = XmlService.getNamespace("<http://www.sitemaps.org/schemas/sitemap/0.9>");
var urls = root.getChildren("url", ns);
var result = [];
urls.forEach(function(entry) {
var loc = entry.getChild("loc", ns).getText();
if (loc.indexOf("/blog/") > -1) { // only blog URLs
result.push([loc]);
}
});
return result.length ? result : [["No /blog/ URLs found"]];
}
[Your Company] Sitemap).=getYourBlogUrls()
The script will fetch the sitemap, parse it, and fill the sheet with all blog URLs.
What it does: Finds the most relevant active communities to contribute to for your company, based on where your customers are most likely to engage.
💡 Adjust the “Fetch Company Info” step to connect to the correct internal documentation solution (Notion docs, Google docs, Smartsuite database, whatever you’re using!).
You can also delete this step if you added enough context in the Company Info tab of your Reddit Mastersheet.
Prompt:
I need your help finding the most relevant Reddit communities and subreddits (/r) to follow and contribute to for $0 (website found at $1) in the last few weeks or months. To make your picks, base your research on two main things: 1. Is the content of the Reddit community aligned/relevant with the company's positioning, market, product, etc. Especially of the ideal customer profile. We want to add value to Reddit threads where our customers are spending their time and consuming content. You can find information about those in the Notion page attached. 2. Is the community active? (Volume, engagement, trending, etc.).
Return the top 10.
❗ To call the google sheet dynamically instead of having “$0”, open the Relay assistant and paste ⤵️
Replace all instances of "$0" with a placeholder that dynamically calls the text value of the Company field.
Replace all instances of "$1" with a placeholder that dynamically calls the text value of the URL field.
What it does: Every week, it will trigger a run of Top Reddit Posts for every relevant community in the Reddit Mastersheet.
What it does: Finds the most relevant posts or threads to contribute to based on the actual content and what you posted on your company blog.
Prompt:
Conduct a thorough search of the Reddit posts attached. Based on your assessment of what $0 ($1) does, its product(s), online content, and more, help me make a list of the most relevant recent Reddit posts to contribute to in each of those communities this week. What I mean by contributing is to add insightful comments, some data, start a conversation, ask a question, or share something that people reading the post will find valuable. The intention is to increase $0's visibility on Reddit, and consequently on LLM queries (Reddit is the #1 source of reference data by LLMs).
Also, read through $0's blog (URLs to every published blog can be found in the spreadsheet attached) to use the company's current content to make your comment proposal. Pick one blog that is most relevant to reference in your proposed comment.
I want you to output:
Give me your top 3 posts to contribute to. Focus on relevancy, reach potential, and ability to contribute value.
❗ To call the google sheet dynamically instead of having “$0”, open the Relay assistant and paste ⤵️
Replace all instances of "$0" with a placeholder that dynamically calls the text value of the Company field.
Replace all instances of "$1" with a placeholder that dynamically calls the text value of the URL field.
❗ If you added more guidelines and information in the Company Info tab of the Reddit Mastersheet, you can always add them as context in the prompt ($2 = reference to the 3rd column, $3 to the fourth, etc.)
What it does: Finds posts where your brand or competitors are mentioned, or posts where your competitors’ employees have engaged.
Prompt:
Search Reddit for posts where either our company <div>Company</div> (<div>URL</div>), or competitors like <div>Competitors</div> (and other relevant competitors that aren't in this list) are mentioned, OR where someone from a competitor’s team has commented.Your task:Return 5–10 of the most relevant, non-archived posts (only active threads).For each post, give:The subreddit + title (linked),A 1-sentence reason why our team should engage (e.g. demand, competitor mention, misinformation, buying signal).A 1-sentence suggestion for how we should contribute that is helpful and not overly promotional (e.g. share benchmarking data, implementation tips, decision frameworks).Focus on threads where our comment could add unique insight (not just “thanks”).Keep the output structured as a table with columns: #, Thread & Link,Why Engage, Suggested Contribution.Exclude threads that are archived or closed for comments.Goal: Produce a prioritized list of threads our team could meaningfully join this week to add value and build credibility.
