Issues with Importing Google Search Results into Existing Table

Andrea Marchiotto · 2024-09-04 19:41:01.649659+00

I was trying to import results in an existing table by adding google search results, based on the following keywords: <https://www.google.com/search?q=site%3Alinkedin.com%2Fcompany+audiovisual+production&sca_esv=bb2e894607922a5f&sca_upv=1&rlz=1C5CHFA_enNL1052NL1052&sxsrf=ADLYWIK7-WipPLfNWd0eLkWme1G-45paYQ%3A1725478457902&ei=ObbYZvvkNqnMkPIPw7eCMA&ved=0ahUKEwi75bOUhKqIAxUpJkQIHcObAAYQ4dUDCBA&uact=5&oq=site%3Alinkedin.com%2Fcompany+audiovisual+production&gs_lp=Egxnd3Mtd2l6LXNlcnAiMHNpdGU6bGlua2VkaW4uY29tL2NvbXBhbnkgYXVkaW92aXN1YWwgcHJvZHVjdGlvbkigCVCbBli1CHABeACQAQCYAX-gAeQCqgEDMC4zuAEDyAEA-AEBmAIAoAIAmAMAiAYBkgcAoAeHAQ&sclient=gws-wiz-serp|https://www.google.com/search?q=site%3Alinkedin.com%2Fcompany+audiovisual+production[…]4zuAEDyAEA-AEBmAIAoAIAmAMAiAYBkgcAoAeHAQ&sclient=gws-wiz-serp> but it looks terrible and did not work. See attached

Issues with Importing Google Search Results into Existing Table | Clay

Channeled
APP
·
·
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Bo (Clay)
·
·
Hey, thanks for reaching out! Before I can help you, could you send me the table URL? We need the URL that's in the address bar at the top, where you type in the website you want to visit. Thanks! 💪
Andrea Marchiotto
·
·
https://app.clay.com/workspaces/334660/tables/t_DwhxZnDEqzSo/views/gv_f4ySmFcSUP7h
Bo (Clay)
·
·
Hey Andrea, Just to confirm, could you explain what exactly you’re trying to do? Are you looking to search for certain information about companies on Google? If so, which kind of information are you hoping to find? It looks like your Google search is formatted like this: site:linkedin.com/company audiovisual production. I’m guessing you’re trying to find mentions of audiovisual production for specific companies. If that’s the case, this would be achieved by adding an enrichment, not a source. For example, you can use the Google Search enrichment. You can find this by going to the Enrichment panel and clicking the “Add Enrichment” button at the top right of the page. Let me know if this helps or if you need more guidance! 😊
Andrea Marchiotto
·
·
I am trying to find companies operating in audiovisual production
Andrea Marchiotto
·
·
as a source
Andrea Marchiotto
·
·
I was just following the example given in the instruction video
Bo (Clay)
·
·
Ah, gotcha! 😊 Why not use our “Find Companies” feature, like you already did? It’s free and would give you more results. But yes, if you decide to add that as a source to an existing table with an already existing source, the data will show up together, and you’ll need to format the data to fit the columns. You can do this by going into the settings of each column and then adding the results from the Google sources by using the forward slash ( / ) to link the data. Let me know if you need any more guidance on this! 😊
Andrea Marchiotto
·
·
Because I was experimenting based on your guidance
Andrea Marchiotto
·
·
There is nothing there though
Andrea Marchiotto
·
·
Just two rows with something on the second column.
Andrea Marchiotto
·
·
Nothing more
Andrea Marchiotto
·
·
Can I add key decision makers in the same table when doing enrichment, instead of creating a new one?
Andrea Marchiotto
·
·
What if I find more than one key decision maker per company
Andrea Marchiotto
·
·
will I get double or triple semi duplicate rows?

19 comments