Hi @aliasghar_marvi
I came across your work as I was also reviewing the same blog post mentioned in your work. I downloaded the workflow from your day 20 and ran the Google search workflow. In the Retrieve Text component node, I’m getting this error - WARN Column Selection Configuration 3:857:0:791 Column ‘URls’ is not part of the table spec anymore. However, I’m not able to find ‘URIs’ anywhere. I’m very much interested in reviewing your work and would appreciate any guidance on this at your convenience.
If anyone else has experience with this type of issue, I’ll truly appreciate any guidance as well.
Thank you very much in advance for your time and help.
The error message tells you that there is no column called URIs.
Did you try configuring the component?
The data coming out of the Google Custom Search component is a single column called “link”.
The Retrieve Text component should work if you tell it to use this column.
Hi @alabamian2 yes I understand your error now. This component must have used its default saved custom value when I was doing it for twitter part. Thanks a lot @elsamuel for helping out. I am sorry for replying this late, but I am glad you were able to figure it out on your own
Also please please give your feedback, my approach is still primitive since I was focused more on just outcome and not the way I was doing it lol. Thanks a lot!
Hi @aliasghar_marvi
Thank you very much for sharing the workflow and replying to my message. My first goal is to be able to take in a large set of SEO keywords (from few hundreds to thousands, shown below in Keyword col) and assign a single label (label1 below) while grouping related keywords together.
I fed 500 kws into Topic Extractor (Parallel LDA) node and it did group kws into topics but the topics are topic_0, topic_1, topic_2 and I want the label to be plain English like home renovation and hloc rates. I would also like to incorporate SERP ranking data, but the blog doesn’t really expand on that portion. I’m going to review your workflow and also do more googling to see if others have done similar attempts. Thank you so much for your work and kindness sharing your work.
