Cant link to a google sheet to locate Linked In URLS

šŸ Getting started.
1

Hi I am trying to create a playbook that populates a Google sheet of prospects with their Linked In URL. I have their name and email. I have been trying to set up an automation but I cannot even get it to read the list properly (it says no data is on the the list, where there is). Can anyone help with this?

2

Hello Dan,

Is there any playbook I can take a look for you? Could you please share it with me here? I will take a look to see if thereā€™s any misconfiguration. To get a link of your playbook, please follow instructions provided here: https://support.bardeen.ai/hc/en-us/articles/28821486098957-Where-can-I-find-the-playbook-link

Generally, we have a help guide on connecting google sheets. Please check if it can help you resolve the problem: https://support.bardeen.ai/hc/en-us/articles/29931926537613-How-to-Integrate-Google-Sheets-with-Playbooks

Victoria

Customer Support - bardeen.ai
Knowledge Base https://support.bardeen.ai/hc/en-us
Explore | @bardeenai | Bardeen Community

3

Thanks Victoria. I have been able to link to the worksheet, but it fails every time I try to read from it. See below for share of the prompt I created. It actions fine, find the worksheet etc, but cannot read any info from it when I put in the columns to read (it says no data found)

Links below. Can you help with this?

Many thanks,

Dan

The link to the worksheet is here:https://docs.google.com/spreadsheets/d/1SbzGIA40uExMeH2nC4AVDJ4l-Uk8jiYk/edit?gid=2126533202#gid=2126533202

Link to prompt here

https://www.bardeen.ai/playbook/community/Task-Overview-Automate-the-process-of-searching-for-LinkedIn-profiles-using-the-Name-and-Email-from-a-Google-Sheets-spreadsheet-and-filling-in-the-LinkedIn-URL-column.-Steps-1.-Connect-to-the-Google-Sheet-where-TFS-applicant-data-is-stored.-Sheet-contains-columns:-ā€œNameā€-ā€œEmailā€-ā€œLinkedIn-URLā€.-2.-For-each-row:-Use-the-ā€œNameā€-and-ā€œEmailā€-fields-to-construct-a-LinkedIn-search-query-in-the-format:-Name-AND-Email.-Open-the-first-LinkedIn-result-in-a-browser-tab.-3.-Extract-the-LinkedIn-profile-URL-from-the-browser-tabā€™s-URL.-4.-Write-the-extracted-LinkedIn-URL-into-the-ā€œLinkedIn-URLā€-column-of-the-same-row-in-the-spreadsheet.-5.-If-no-matching-profile-is-found:-Leave-the-ā€œLinkedIn-URLā€-field-blank-or-write-ā€œNot-Foundā€.-Notes-Use-Bardeenā€™s-Web-Search-and-Google-Sheets-Integration-tools.-Automate-up-to-20-searches-at-a-time-to-avoid-triggering-rate-limits.-Log-any-errors-(e.g.-name-mismatch)-into-a-separate-ā€œErrorsā€-column.-Actions-to-Automate-Use-Bardeenā€™s-search-actions-to-find-LinkedIn-profiles.-Extract-URLs-directly-from-the-browser-or-search-results.-Update-Google-Sheets-with-the-LinkedIn-profile-URL.-h7Un2GgSqplPWiaQNM

Dan Wallman

Founder, TechNative Digital

dan@technativedigital.com

www.technativedigital.com

Mob: 07782330250

![A picture containing logo, symbol, font, graphics

Description automatically generated](https://support.bardeen.ai/attachments/token/GE87kTstdFVoPnmFJ9OdOsEGg/?name=image001.png)

4

Hi Dan,

I think it is failing because of .xlsx in filename. Could you please try saving this sheet as a google sheet and connecting that one to Bardeen?

Victoria

Customer Support - bardeen.ai
Knowledge Base https://support.bardeen.ai/hc/en-us
Explore | @bardeenai | Bardeen Community

5

Thanks I will try that!

Can I also make a second enquiry? When I attempt to connect to Hubspot I hget a message saying the account does not have the right permissions. Im pretty sure I connected it previously but it dropped off. Im on the marketing hub Starter subscription.
Screenshot 2025-01-14 at 14.58.38

6

Hi Dan,

As far as I know, you will need permission to install public apps in Hubspot. It may be possible that only admins in Hubspot can install public apps. You can find more details on this page: Hubspot Permission Requirements https://developers.hubspot.com/changelog/new-permission-requirements-for-installing-public-apps
Additionally, Bardeen will require the following scopes to function properly:

  • Edit and delete contacts
  • Edit and delete companies
  • Edit and delete deals
  • Edit and delete tickets
  • Edit tasks

Please let me know if this helps or not.

Victoria

Customer Support - bardeen.ai
Knowledge Base https://support.bardeen.ai/hc/en-us
Explore | @bardeenai | Bardeen Community

7

Hi Victoria,

Thanks for getting back to us. Iā€™m a Super admin in Hubspot and should be able to do all of the things you mentioned below. I emailed HubSpot support and they did not know why it was not working and recommended I emailed you guys.

It would be great to get this working, I am sure it linked before as the app was installed in Hubspot but I removed it when it was not allowing me to link them thinking I could reinstall it and it would work again.

I think this is a glitch and needs resetting somehow as no reason why it would not work. Can you please advise how I can get this all talking to each other?

I signed up for a month of Bardeen with the intention of using it for this purpose but have stalled due to this issue. I have not used it so far since singing up, could I pause or restart my membership as currently I am not able to link the two together?

Many thanks,

Dan

Dan Wallman

Founder, TechNative Digital

dan@technativedigital.com

www.technativedigital.com

Mob: 07782330250

![A picture containing logo, symbol, font, graphics

Description automatically generated](https://support.bardeen.ai/attachments/token/VlX8nCCsovtwOUj05XiukzXAr/?name=image001.png)

8

Hi Dan,

Our advanced integrations like HubSpot are only available on Business Plan or higher. That could be the reason you see the error. Would you like to get in touch with our Sales Team for exploring the options?

Looking forward to your reply.
Victoria

Customer Support - bardeen.ai
Knowledge Base https://support.bardeen.ai/hc/en-us
Explore | @bardeenai | Bardeen Community