Hey Devs!
I am playing around with the SEO Automation Tool URL Profiler.
Unfortunately, I have a problem that I can't seem to solve:
I am trying to create a database of our competitors websites. This includes technical info and Screenshots.
What I am trying to achieve is, obtaining a spreadsheet with all data points PLUS a link to the saved screenshot.
THE PROBLEM:
URL Profiler gives me a spreadsheet with all the info AND a separate Folder with the downloaded Screenshots.
QUESTION:
How can I get the Screenshots sorted to the right company info? So that in the end I have a spreadsheet with all info in one place. As of now, I would need to manually upload the screenshots to the (Airtable) Spreadsheet.
Do you know a solution to that? Or maybe another way of going around that?
Thank you!
If I understand your problem correctly, then you get the excel file from the tool, with 2 important columns: "URL", and "Screen Capture Path".
And you want the path column not to only contain the folder path, but the full path to the image of the url.
This can be solved by a simple excel formula.
But this way you will only have a link to the correct image files in Excel, but in Airtable you can see the image preview aswell.
So the final question is: Do you want to automatically upload everything correctly to Airtable?
Yeah so what I get is one Excel Sheet with the URL and the corresponding SEO Data + A column where the Screenshot Path should be. Ho"wever, it nearly always says "Check Failed - HTTP Status MovedPermanently", so i think not even that works correctly.
Separately, I get a folder on my desktop where all Screenshots are thrown into.
So now I am figuring out a way of combining the Excel Sheet with the corresponding Screenshot.
So that in the end I have a database of the seo data, url, AND screenshot path. (That I could then visualize in another program for better oversight).
Does that make sense for you?
Thanks for the reply!
I am not sure what technical information you are collecting but I would attack this with Python and the Selenium package saving each screenshot with the URL of the website.
The url profiler tool does this already, I believe the problem lies elsewhere.