Welcome 🎉! Cohesive is an AI data enrichment tool that allows you to leverage AI, research accounts and contacts, and validate emails all within Google Sheets

This resource contains a list of Cohesive Formulas along with common use cases. Feel free to send me an email at [email protected] or join our Slack channel if you have additional questions.

Post-Install Instructions

• Refresh your Google spreadsheet, go to Extension > Cohesive AI > Enable and wait for the pop-up to finish loading (generally you only need to do this once for each document, but in the future if the formulas do not work, please always try this first).
• Make a copy of this template Google Sheets file to get started quickly.
• Remember to bookmark this site for additional future reference.

<aside> 💡 To upgrade for more credits, click on Extension > Cohesive AI > Usage & Billing You can then select a plan in the dropdown to upgrade to.

</aside>

List of Formulas

🪚 Hint: [dynamically reference other cells in the formula using ampersands](https://support.google.com/appsheet/answer/11577479?hl=en#:~:text=You can include CONCATENATE(),for the CONCATENATE() function.) (&). For example, if cell D2 contained cohesiveapp.com, =COHESIVE_WEBSEARCH(”owner of”&D2) would be the equivalent of =COHESIVE_GPT(”owner of cohesiveapp.com”)

Common use cases for these formulas are in this template Google Sheets file.

TWO LETTER STATE CODE: CA) | California | Asks ChatGPT to return a response based on your question or request | | =COHESIVE_WEBSEARCH(Google search request, [optional] specific instructions for the google search result ) | 1 Research | Simple version: =COHESIVE_WEBSEARCH("owner of cohesiveapp.com")

Advanced version: =COHESIVE_WEBSEARCH(”owner cohesiveapp.com”, “Return the full first and last name of the owner of cohesiveapp.com. No abbreviations are allowed. Return empty string if none found”) | Kevin Zhang | Uses AI to perform a Google Search and find information based on the search results.

The advanced version allows you to provide specific or custom instructions to AI | | =COHESIVE_AGENT(URL, What to answer from the website) | 1 Research | =COHESIVE_AGENT("cohesiveapp.com", "Return a 1-2 word description of what cohesiveapp.com does.") | Virtual Assistants | Uses AI to visit the website and answer the question.

Note: it goes to more than just the given URL. It will also navigate to other pages in the URL that AI thinks is the most likely to contain the information needed | | =COHESIVE_EMAIL(first name, last name, website domain, [optional] existing email to validate first) | 1 Data Enrichment | =COHESIVE_EMAIL("Kevin","Zhang", "cohesiveapp.com") | [email protected] + valid status in two separate columns

P.S., feel free to contact me if you have any questions or suggestions! The email is indeed valid 🙂 | Uses email validation vendors to find a valid email for the provided contact. If an optional email is provided into the formula, it will first test the provided email to determine the validity.

Note: the formula will test several common email patterns, like [email protected], to see if any are valid | | =COHESIVE_BUSINESS_LINKEDIN(company Linkedin URL) | 4 Data Enrichment | =COHESIVE_BUSINESS_LINKEDIN("linkedin.com/company/cohesiveapp/") | Various information from the Cohesive company LinkedIn page, like employee range, company description, etc. | Scrapes the company LinkedIn page to pull all information found on the LinkedIn page | | =COHESIVE_PERSONAL_LINKEDIN(person Linkedin URL) | 4 Data Enrichment | =COHESIVE_PERSONAL_LINKEDIN("linkedin.com/in/kevindzhang/") | Various information from the person’s LinkedIn profile, like location, work experience, educational history, etc. | Scrapes the person’s LinkedIn page to pull all information found on the LinkedIn profile | | =COHESIVE_PERSON_LOOKUP(job title, website domain ) | 6 Data Enrichment | =COHESIVE_PERSON_LOOKUP(”CEO”,”cohesiveapp.com”) | linkedin.com/in/kevindzhang/ | Searches our database to find the LinkedIn URL of the person closest to the job title specified. For example, searching “owner” of “cohesiveapp.com” will return linkedin.com/in/kevindzhang/, the Co-Founder and CEO of Cohesive | | =COHESIVE_PHONE_LINKEDIN(linkedin URL) | 20 Data Enrichment (only if person found) | =COHESIVE_PHONE_LINKEDIN(”https://www.linkedin.com/in/hansae-catlett-436a9b21/”) | 19178032771 | Looks for a person’s phone number based on their Linkedin URL | | =COHESIVE_PHONE(name , address) | 20 Data Enrichment (only if person found) | =COHESIVE_PHONE(”Sieva Kozinsky”, “Los Angeles, CA” | (415) 596-6527 | Looks for a person’s phone number based on their name and address. Will return a list of potential mobile and landline phone numbers, ranked by likelihood of being correct |

Some Prompts To Get Started

Here are some prompts we use internally, using example inputs

This should be the most casual name, which often is the name by which the company refers to themselves. This can be shorthand or an acronym. At minimum, you should always remove any legal suffixes like Inc or LLC from the company name.”) | | Generate a 2-3 word description of the company for personalization | =COHESIVE_AGENT(”cohesiveapp.com”, "Return a 1-3 word description of the company. This must follow the rules below. Also refer to the examples below.

RULES:

• Must be 1-3 words long
• Must end in Services
• Must be in proper case

EXAMPLES:

• Outsourced Accounting Services
• Fractional CFO Services
• Legal Services”) | | Determine whether a company is a fit based on industry focus | =COHESIVE_AGENT(”cohesiveapp.com”, "Does the company offer outsourcing services? This can be any type of outsourcing, offshoring, or nearshoring.

Return yes or no only”) | | Find contact emails | =COHESIVE_EMAIL(”First Name”, “Last Name”, “Company Website Domain”) |