what?
For larger technical SEO audits, we utilised ChatGPT to create a script for Google sheets that bulk imports multiple files at once, and then created rules for organising and formatting these sheets.
why?
We realised we were spending a significant portion of our time during technical audits organising spreadsheets and importing various sheets for different locations. This was time consuming and ate up time better spent analysing the various issues that had come up in the various site crawls.
ChatGPT is a great tool for this task, allowing you to iterate and pick up where you left off in a ‘conversation’, troubleshooting and tweaking the script it provides until it eventually works. By originally importing spreadsheets in bulk, I was then able to format each one by adding additional lines to the original script, and then further organise these sheets in an alphabetical order so they’d be easier to work through.
THE OUTCOME
This specific tech audit presented a huge number of issues present on the website. Importing each sheet one by one, formatting them and naming each tab would have taken hours alone.
Utilising ChatGPT to speed up this process afforded us more time to focus on evaluating the issues themselves and identifying the highest priorities to bring to the client. Since creating this script, we use it on other large technical SEO audits.
For other technical issues, where it may have originally required advice from a developer, AI can also often be a useful tool for explaining why a certain piece of code is incorrect, or providing examples of working code.
