There really isn’t any way around this. Once you have these, then you can mass create pages.
Step 1: Create an Airtable Base.
In this example we are going to create 100 pages for “Optimize Your Marketing in [City]”.
We will create some fields that will include the target keyword (which in this case is just “Optimize Your Marketing in [City Name]”), the city excerpt, city image, and last but not least the URL slug.
Once this is done, you are almost completely done with airtable.
Some tips for filling this out would be to use ChatGPT to write a few sentences for your excerpt field, and to use Google Images to quickly find images that are super relevant to your target keyword.
It’s important to keep these as single line fields because we will need to pull them into Webflow that way.
Step 2: Create a Webflow collection.
When we are in Webflow, we are going to navigate to the collections tab on the left hand side of screen and select create a new collection.
Please note, you will need the CMS plan or at the very least, a starter plan to create these pages.
At this point, all you need to do is copy over the same field headers into this collection.
All of your info from Airtable will be sent over to Webflow once you create the Whaleysnc. We will be getting to that step soon, but first, we need to do one more thing.
Step 3: Design your Webflow Template page.
Webflow excels at creating a CMS page where you can place dynamic content in pages.
It’s super important to create the collection first, that way when you go into your pages tab, then you can see the new dynamic page that will be pulling info from the collection you just created.
So go through and design the page.
Once you have a page designed the way that you want - now it’s time to place the collection items into the page.
I recommend that you place the longtail keyword in the H1 Text, and have it listed at least one more time in the excerpt.
Ideally, you are able to place the longtail keyword in an H1, H2, H3, and paragraph - but that would be a bit more writing on your part in the Airtable base.
It is completely up to you - but the reason why we like these PSEO pages is because it is done very quickly.
The less things that need added to the Airtable, the faster the process.
Publish your site.
Now, let’s move on to the second to last step!
Pro tip: Create 5 sample items in your collection to see content on your page once you map the items to your collection. After you do that, then you can delete them and publish your site.
Step 4: Create a Whalesync account and create a sync between Airtable and Webflow.
Using the Whaleysnc account, you can quickly map the fields from the Airtable to the collection fields in Webflow.
Be sure to have your site published before you go through with the sync, otherwise you will get an error that the collection isn’t published.
Pay particular attention to the sync in the middle.
In my experience, it is safer to sync from Airtable to Webflow only - simply because if you mess up your sync, then you Airtable isn’t completely erased.
In fact, the first couple times you do this, definitely duplicate your Airtable base before the sync just in case there are any issues.
With that being said, once you have the sync ready to go - then hit sync!
Step 5: Check Webflow and publish!
Now all you need to do is check if all the Airtable items made it to Webflow!
Most of the time there are no issues if the site was published before the sync occurs - so in this case we are pretty much done.
So depending on the number of Airtable fields you created, you could have made 100s of PSEO pages with this process.
This is something that we do with all of our clients because SEM is so important.
If you have any questions, please don t hesitate to reach out.
Until next time…
To your success, Ian “Your Favorite Growth Hacker” Binek
Subscribe if you are new 🖱
We bring an analytical, and no BS approach to bringing A+ marketing to your B2B SaaS startup. Subscribing may be the best offer you have been made all day. Literally free, ninja tips that work. And I notify you when I make a new post. You tell me who is winning here. I'll wait.
The blog highlights nine free Chrome extensions that the author finds useful for daily use. SimilarWeb provides website statistics, visitor behavior, and traffic sources for competitor analysis. Wappalyzer helps to determine website characteristics such as installed pixels, website builder, and CRM.
The blog argues that traditional SEO methods, such as hiring an agency to optimize your website and write SEO-optimized blog posts, may not be effective for B2B SaaS startups entering new markets with no existing search volume. Instead, the author suggests that startups should focus on creating informative and unique content through regular blog writing, even if it's just a few short paragraphs each week.
The blog post discusses the importance of determining the appropriate advertising budget for B2B SaaS startups. The author emphasizes that there is no one-size-fits-all approach to determining the budget and highlights the need to consider various variables. The article outlines six steps to calculate a realistic marketing budget for a B2B SaaS company.
Download 100 Social Media Post Ideas + Post Tracker For B2B SaaS Startups
Who doesn't love free stuff. Be sure to pick up a copy of our beast social media post idea sheet before going. You'll thank us later.