Thread by @RankSense

#RSTwittorial Add Calls-to-Action to Meta Descriptions in #GoogleSheets with #Python 🐍🔥

Here's the output👇

Click on the button that says “Open in Colab"
github.com/ranksense/Twit…

Why learn this? 🧐

Skip the tedious work of updating 100s or 1,000s of meta descriptions and let this script do it for you! Speed up your processing time from 30 sec/URL to 3 sec/URL 🤯

💻 A #Google account
🕷️ A #Crawler tool (optional, but it helps find a large number of URLs quickly)
⌚️ A couple of minutes

Here are the steps:

✏️ Copy the notebook
✏️ Create a spreadsheet
✏️ Modify the parameters in the code

Let's get started!

1⃣ Create a copy of the notebook so you can modify it

2⃣ Create a #GoogleSheet and load in your URLs obtained, either manually or from a crawling tool

These URLs should have the meta tags that need an append

3⃣ Modify the parameters:

🗒️ Call to action
🗒️ Starting row
🗒️ Ending row
🗒️ Which column to place the original meta tags
🗒️ Which column to place the updated meta tags

Hit run and let the script take care of the rest🥂

Here’s your #hw:

🛠️ Modify the variables to append calls-to-action to meta TITLES 🛠️

We encourage you to share your results, thoughts, and anything else below!

Get it right and get retweeted by @hamletbatista & potentially featured in his monthly column! 🐍🔥

Good luck!🤞