I’m currently building a lead scraping tool with dashdash.
After trying to figure out two formulas in my spreadsheet, which don’t really want to work, I finally surrender and kindly ask for your help
- After searching for companies, I would like to insert certain results into the next table. (company results to people table). For this I’m using the INSERT function. The function however doesn’t always work. Some companies get transferred , some just don’t get copied to the other table.
As far as I understood, the formula should copy A2:H2 (and so on) to the next free row in the People Results table. Am I missing something here/ is there a better formula?
=IF(L2=“Copy Company”,INSERT(A2:H2,‘People Results (LinkedIn)’!A$1:H$1),“Press ‘Button’”)
- When the companies are then in the next table, I want to get the LinkedIn profiles that match the company name (column “A”) and the job titles in column “N”.
I actually took the formula from the “find companies and leads”-template, but it doesn’t work properly in my sheet. It gives me people with the right job titles, but completely random companies without any connection to the company that I was looking for.
Any ideas why this one isn’t working for me?
=IF(OR($P$1=“GET ALL”,P2=“GET PROFILES”),SEARCH_PROFILES_LINKEDIN(N2,A2,IF(O2,“true”,“false”)),“Press ‘Get Profiles’”)
Little additional question: when using SEARCH_PROFILES_LINKEDIN, is 100 results/ JSON Items the max you can get for one search?
Thanks so much for the input in advance!