Finally, After 2 years of using ChatGPT, I can say it’s the most life-changing tech since the Internet.
Here are 10 prompts that transformed my day-to-day (and can do the same for you):
1. Learn anything from a 20-year expert
“Act as a 20-year expert in {topic}. Break down the core principles a beginner must know. Use analogies, step-by-step logic, and explain like I’m five.”
2. Brutally honest thought partner
“Be my thought partner. I’ll share {idea/problem}. Question every assumption, surface blind spots, and help evolve it into a 10x better solution.”
However, going through posts one by one takes a lot of time.
Here are the questions I use to find catchy ideas, ad copy, and offer concepts from many subreddits at the same time, for free, using ChatGPT Agent:
Prompt #1
This is the prompt we use to gather the data and have ChatGPT return it to us in a format that's not filled with code.
*You have to run this in Agent mode otherwise it won't work.
This is quite long, so you might want to bookmark this:
###
OBJECTIVE
You are tasked with scraping Reddit content for structured analysis. You will be given one or more Reddit URLs, each of which has already been filtered to show the *Top Posts from the past month* on a specific subreddit.
Your task is to scrape *25 full posts per URL*. Each post must include:
1. The *post title* (first line)
2. The *body content* of the post (second line)
Do not include any other metadata such as votes, usernames, or timestamps.
PROCESS
For each provided URL:
1. Load the page and identify the first 25 post links (ignoring stickied or promoted posts).
2. For each post:
* Open the post
* Scrape the title
* Scrape the body content using the following structure:
* Target the
element with class: text-neutral-content , slot: text-body
* Traverse into: div.mb-sm.mb-xs.px-md.xs\:px-0 , then into div.md.text-14-scalable[property="schema:articleBody"]
* If the body content is missing, leave the second line blank
* Return to the post list and continue to the next one
3. After 25 valid posts, stop and move to the next subreddit URL.
OUTPUT FORMAT
• Each post must be exactly *two lines*:
* Line 1: Post title (raw text)
* Line 2: Post body content (raw text — preserve paragraph breaks)
• Leave *one blank line* between each post
• Return the output in either plain text or Markdown (whichever preserves formatting best)
• Do *not* return JSON unless specifically requested later
ERROR HANDLING
If a post fails to load or doesn’t contain extractable content, skip it silently and continue until 25 valid posts are scraped per URL.
FINAL USE
This data will be ingested into a downstream NLP tool. Do not summarize or rewrite anything. Extract only the raw post title and post body.
REDDIT URL LIST
Below are the subreddit URLs you should begin scraping. Each URL is already filtered to show Top Posts of the Past Month. Scrape 25 valid posts from each:
**Insert your sub-Reddit URLs of choice here, with time and trending settings already configured. e.g. Top posts from last month**
**Stack them vertically one by one**
🚨BREAKING NEWS: ChatGPT now works inside Excel & Google Sheets.
No more memorizing formulas.
No more messy functions.
Here’s how to use AI to EXCEL at Excel:
Numerous is an add-on that can prompt ChatGPT inside Excel or Google Sheets for many tasks such as writing, researching, translating, rewriting, and more.
It can help you streamline your work and increase productivity.
Here's how it works:
You can use ChatGPT in Excel or Google Sheets for data analysis with Numerous AI for things like:
• Reformatting phone numbers
• Classifying customer review topics
• Removing names from support emails
• Sentiment analysis of customer reviews