DeepakNess Profile picture
Sep 2 4 tweets 1 min read Read on X
For a recent project, I have to build a directory website, and here's what I'm going to do:

1/ Scrape Google Maps listings (Octoparse)
2/ Scrape up to 50 reviews for those listings (Octoparse)

👇
3/ Do a sentiment analysis of reviews and generate a short summary using a custom script (OpenAI API)
4/ Crawl their websites, if any (Firecrawl API)
5/ Extract a list of services offered and facilities available (OpenAPI API)
6/ Finalize final data points
7/ Design the website by presenting the data in an appealing and user-friendly way

I will be creating separate pages for different cities, but listings won't have separate pages of their own.
Everything will be done by custom Python scripts along with the SQLite3 database.

I will share more details as the project progresses.

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with DeepakNess

DeepakNess Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @DeepakNesss

Sep 10, 2024
Last week, I spent 40+ hours creating landing page style programmatic pages using WP All Import and Gutenberg.

For this project, I had to:

◉ Develop a WordPress plugin
◉ Use PageSpeed & SimilarWeb APIs
◉ Prepare ~100 columns of data
◉ Design pSEO template

And much more... Programmatic SEO Examples Page on UntalkedSEO
@UntalkedSEO Before I explain how it's being done, you can check all these pSEO pages on @UntalkedSEO website through below URL: untalkedseo.com/examples/
Some overview before moving forward:

◉ UntalkedSEO is built in WordPress
◉ Uses @BuildWithOllie theme
◉ Google Sheets contains data for pSEO pages
◉ WP All Import plugin for automation
◉ ACF plugin for creating custom post types and custom fields
◉ A custom plugin to make custom post types dynamic
◉ Using Google PageSpeed API to get Core Web Vitals data for URLs
◉ Using SimilarWeb API for traffic and competitors related data
◉ Document Studio Google Sheets AddOn (by @labnol) for automating featured images
Read 7 tweets
Jul 22, 2024
Moved the Programmatic SEO eBook from Writebook to a simple static site, and this is how it looks now.

Earlier, I had to pay server costs, but now it's hosted for free on Netlify. 🥳

👇 Image
Access the eBook: ebook.untalkedseo.com
The only major issue with Writebook – I had to pay for the server.

Since all the pages were completely static and didn't need to be updated frequently, I decided to use a static site generator 11ty to publish the ebook.

And made the solution available for everyone. 👾
Read 6 tweets
Jul 5, 2023
I've written a custom script that integrates OpenAI directly into Airtable, no 3rd party tools needed! Works on free Airtable account as well.

All you require is the OpenAI API, select your preferred model, and you're good to go.

Perfect for programmatic SEO!

Script below 👇
You can get the script here 👇

deepakness.gumroad.com/l/egkbuo
The script is used inside the Airtable's Scripting extension.

Just copy-paste the script and:

- Select the table
- Provide input & output fields
- Paste your OpenAI API
- Enter max tokens
- Select the OpenAI model

And just hit Run! Image
Read 6 tweets
Jun 27, 2023
How to use WordPress Gutenberg blocks inside WP All Import for programmatic SEO:

➭ Create a new page and design it however you want by using Gutenberg blocks

➭ After designing, open the Code editor to see the code version of the design (as shown below)

Continued... 👇 Image
➭ Select all the code and copy it to your clipboard

The code editor will look something like the screenshot below. Image
➭ Now, start setting up WP All Import and use the copied code by pasting it inside the "Text" editor

➭ Replace the required text with variables

And you're done! 🎉 Image
Read 5 tweets
Apr 3, 2023
Haven't done it since the launch, so here it is:

🎉 Offering a massive 60% discount on the Programmatic SEO OS course.

So if you want to master the art of pSEO and still haven't got the course, now is the chance.

Here's the complete curriculum 👇

deepakness.gumroad.com/l/hzsas/SALE120
Here's everything that's covered in the Programmatic SEO course:

📃 Image
Apart from this, I am also planning to do a detailed video on how I have programmatically created these pages:

I will share everything (dataset, template, and setup) in the video. And the video will be updated in the course when ready.pseoos.com/examples
Read 4 tweets
Dec 30, 2022
You can use Canva's Bulk Create feature to create images in bulk for your programmatic SEO projects.

1. Create a template
2. Select bulk create
3. Upload the CSV data
4. Map the relevant fields
5. Click Generate and you're done

Here's a quick video showing the same 👇
This is suitable for a low number of pages (50–100 pages), as you will have to map the images manually.

But if you're creating 100s of pages, you will need a solution that is automated.
Probably you need the Canva Pro account for this.
Read 4 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us!

:(