Andrew Charlton’s Post

Crawl URLs at scale in Google Sheets 🤯 (Coming soon to Keywords in Sheets 2.0) Extract data with this simple scraper to quickly identify technical SEO issues ⚙️ It includes: 1. Status Code 2. Indexability (new) 3. Indexability Status (new) 4. Page Title 5. Meta Description 6. H1 7. H2 (first heading or all as comma-separated) 8. H3 (first heading or all as comma-separated) 9. Meta Robots 10. Canonical URL 11. Word Count 12. # of Internal Links (new) 13. # of External Links (new) 14. Internal Links (comma-separated) (new) 15. External Links (comma-separated) (new) 16. Schema Types (new) 17. Custom Extraction (with css selectors). This is one of many new features in Keywords in Sheets 2.0. Sign up for launch updates using the link in the comments below 👇

"Sheet Copilot, get the last 12 months clicks and impressions and plot on a line chart." - Imports Search Console data - Aggregates daily clicks and impressions to monthly - Creates line chart (not yet released but coming soon)

Watch me automatically compare search query performance vs the previous year using AI 🤯: This is our Search Console connector inside Sheet Copilot. And it's now working very well (unreleased). See it automatically compare search queries vs the previous year below. In the video, it: - imports the data for Jan 24 & Jan 23 - adds both imports to the same sheet - creates a unified table with metrics for Jan 24 vs Jan 23 for the same search queries What do you think? What else would you like to see it do?

Introducing Fully Automatic Mode 🤖 ⚙️ Sheet Copilot now runs tasks on its own in Google Sheets. It has 3 new chat modes 👇 ➡️ Assisted (default): Works with you, asking for feedback and approval. ➡️ Semi Automated: You okay the plan, then it does the work. ➡️ Fully Automated: Runs tasks on its own, asks you only when needed. Watch it format the sheet below automatically on request. No questions asked - just does it! 👇 What do you think? #AI #chatbot

I've spent over a year developing the new Keywords in Sheets. Finally, I can start to reveal what it can do...😬 Here's our first bulk function: XML Sitemap It processes XML sitemap indexes at scale and saves the results to a new sheet. This is one of many new features in Keywords in Sheets 2.0. Sign up for launch updates using the link in the comments below 👇

Imagine if AI could import your Search Console data... and then analyse it for you in Google Sheets? ✨ Wouldn't that be something! 🤯 I've got this working in Sheet Copilot 😬 (It's not released just yet and is still very much experimental). Check out the video below to see it in action! It seems I've got a lot of work to do on my old freelance site 😂 #AI #SEO

Here are two questions you should be asking yourself when using AI in your SEO strategies: 1. What useful thing you do is no longer valuable? What can you delegate to AI that you used to spend time on? - briefs? - meta descriptions? - reporting? 2. What impossible thing can you do now? If you can (soon) infinitely scale resource. What does that look like? Can you: - Scale content development? - Increase content distribution? - Include stronger research in content? - Provide more thorough reporting insights? Think where AI is heading. How are you starting to prepare now? #AI #SEO

SEO is facing the biggest shift I've seen since I first started in the industry. AI is changing how we search for things, and it's changing how I search too! Check out the video to see how I recently found a new car seat. It was easier. Is it a tomorrow problem? Maybe not. But it's coming, and soon. I'm not sure yet how we prepare for it. What are you doing?

Sheet Copilot made the top 10 🎉 Thanks for voting on Product Hunt on Friday 👏

Code interpreter for Google Sheets Sheet Copilot now automatically runs Apps Script and gives you the code. Link below 👇 #ai #googlesheets