Chat GPT for Google Sheets: Bulk Page Title, Meta Description & URL Slug Creation

Creating on-page SEO parameters in bulk takes time and effort, which can slow down execution. To save time and effort, we can use the Chat GPT extension in Google Sheets to quickly generate metas and enhance our SEO strategy.

How to integrate Chat GPT in Google Sheets -

Steps -

• Go to Google Sheet

• Click on Extension

• Click on Add ons and then Get add ons

• Search “Chat GPT for Sheets”

• Click on the first extension GPT Workspace and Install the extension

• Once you have installed the extension, for the first time you need to run the extension. For the same, you need to click on extension then click ‘GPT for Docs” and click on start.

• On the right-hand side you will see a panel of GPT Workspace

• You can close that window, now we are all set to give the command and get the output. For the page title, we will use the prompt “create seo optimised exactly of 50 characters” and for Meta Description we will use “create a short seo optimised meta description of exactly 160 characters which leads the user to click on the result”. The syntax will start with “=gpt”.

Here the summary is in cell “B4” and the prompt for Page Title is in cell “C2”, so I will use a syntax -> =GPT(B4,C2) to get the output and it goes the same for the Meta Description.

• Output Result

• Now for the URL slug, we will use a formula -> =LOWER(SUBSTITUTE(TRIM(REGEXREPLACE(c4, "[^a-zA-Z0-9\s]", "")), " ", "-")). the formula considers “page title” that will be in a lowercase case and will not use numbers and special characters which is ideal for an SEO-optimised URL.

You have successfully set an Automated sheet for bulk meta creation, Have attached a G Sheet link which you can copy and use for your projects -

https://docs.google.com/spreadsheets/d/1z7LDmbF9l_o5phTSrVBod5AGdmDtbYkNoHTtWvCNpNY/edit?usp=sharing

If you have any other inputs to improve this further please comment or let me know. Let's learn and grow together.

You can also join the Whatsapp Community for new updates, hacks and strategies -

https://chat.whatsapp.com/L6lnuC6ftoA1Np7yVDp9s7