Looks up each company on your list in a business database and appends its size, industry, founding year and head office as columns.
Uses
Datagma
Google Sheets
Fill in the facts about the companies on your list
Run every day.Run every day.
Set sheetUrl to blank.Set sheetUrl to blank.Set companyTab to Companies.Set companyTab to Companies.Set factsTab to Company facts.Set factsTab to Company facts.Set maxRowsRead to 200.Set maxRowsRead to 200.Set maxLookups to 25.Set maxLookups to 25.
Trim sheetUrl and save it as sheetAddress.Trim sheetUrl and save it as sheetAddress.Trim companyTab and save it as sourceTab.Trim companyTab and save it as sourceTab.Trim factsTab and save it as resultsTab.Trim factsTab and save it as resultsTab.
Get today's date and save it as checkedOn.Get today's date and save it as checkedOn.Set alreadyDone to an empty list.Set alreadyDone to an empty list.Set logWasRead to false.Set logWasRead to false.
If a step below fails, save the error as logErrorIf a step below fails, save the error as logErrorTry
Google SheetsRead column 2 of resultsTab in sheetAddress. Save it as logColumn.Read column 2 of resultsTab in sheetAddress. Save it as logColumn.
Count the items in logColumn.values and save it as logCount.Count the items in logColumn.values and save it as logCount.
Show in the output: Rows already on the facts tab: logCount as text.Show in the output: Rows already on the facts tab: logCount as text.
Change alreadyDone to logColumn.values.Change alreadyDone to logColumn.values.Change logWasRead to true.Change logWasRead to true.On error
Show in the output: Could not read the facts tab: logError as text.Show in the output: Could not read the facts tab: logError as text.
If logWasRead is noIf logWasRead is noYes
Stop and report a problem: The facts tab could not be read, so this run cannot tell which companies it has already looked up and nothing has been written. Add a tab with the name in the 'factsTab' step whose first row reads: Checked on, Company, Looked up as, Match, Name on record, Industry, Employees, Company size, Founded, Headquarters, Website, LinkedIn, Confidence.Stop and report a problem: The facts tab could not be read, so this run cannot tell which companies it has already looked up and nothing has been written. Add a tab with the name in the 'factsTab' step whose first row reads: Checked on, Company, Looked up as, Match, Name on record, Industry, Employees, Company size, Founded, Headquarters, Website, LinkedIn, Confidence.No
No steps
Google SheetsRead the rows of sheetAddress. Save it as sheet.Read the rows of sheetAddress. Save it as sheet.Set lookedUp to 0.Set lookedUp to 0.Set skippedNoName to 0.Set skippedNoName to 0.Set skippedAlready to 0.Set skippedAlready to 0.Set failedCount to 0.Set failedCount to 0.
For each row in sheet.rows:For each row in sheet.rows:If lookedUp is greater than or equal to maxLookups multiplied by 1If lookedUp is greater than or equal to maxLookups multiplied by 1Yes
Stop repeating.Stop repeating.No
No steps
Trim row.Company and save it as companyName.Trim row.Company and save it as companyName.If companyName is empty or companyName is nullIf companyName is empty or companyName is nullYes
Add 1 to skippedNoName.Add 1 to skippedNoName.Skip to the next item.Skip to the next item.No
No steps
If alreadyDone contains companyNameIf alreadyDone contains companyNameYes
Add 1 to skippedAlready.Add 1 to skippedAlready.Skip to the next item.Skip to the next item.No
No steps
Trim row.Domain and save it as companyDomain.Trim row.Domain and save it as companyDomain.Set lookupValue to companyName.Set lookupValue to companyName.If companyDomain isn't empty and companyDomain is not nullIf companyDomain isn't empty and companyDomain is not nullYes
Change lookupValue to companyDomain.Change lookupValue to companyDomain.No
No steps
If a step below fails, save the error as lookupErrorIf a step below fails, save the error as lookupErrorTry
DatagmaEnrich lookupValue with Datagma. Save it as enriched.Enrich lookupValue with Datagma. Save it as enriched.Set wasFound to enriched.found is true.Set wasFound to enriched.found is true.Set companyFacts to enriched.company.Set companyFacts to enriched.company.Set foundText to No match.Set foundText to No match.Trim companyFacts.name and save it as factName.Trim companyFacts.name and save it as factName.If factName is nullIf factName is nullYes
Change factName to blank.Change factName to blank.No
No steps
Trim companyFacts.industry and save it as factIndustry.Trim companyFacts.industry and save it as factIndustry.If factIndustry is nullIf factIndustry is nullYes
Change factIndustry to blank.Change factIndustry to blank.No
No steps
Trim companyFacts.employee_count and save it as factEmployees.Trim companyFacts.employee_count and save it as factEmployees.If factEmployees is nullIf factEmployees is nullYes
Change factEmployees to blank.Change factEmployees to blank.No
No steps
Trim companyFacts.company_size and save it as factSize.Trim companyFacts.company_size and save it as factSize.If factSize is nullIf factSize is nullYes
Change factSize to blank.Change factSize to blank.No
No steps
Trim companyFacts.founded and save it as factFounded.Trim companyFacts.founded and save it as factFounded.If factFounded is nullIf factFounded is nullYes
Change factFounded to blank.Change factFounded to blank.No
No steps
Trim companyFacts.headquarters and save it as factHeadquarters.Trim companyFacts.headquarters and save it as factHeadquarters.If factHeadquarters is nullIf factHeadquarters is nullYes
Change factHeadquarters to blank.Change factHeadquarters to blank.No
No steps
Trim companyFacts.website and save it as factWebsite.Trim companyFacts.website and save it as factWebsite.If factWebsite is nullIf factWebsite is nullYes
Change factWebsite to blank.Change factWebsite to blank.No
No steps
Trim companyFacts.linkedin_url and save it as factLinkedin.Trim companyFacts.linkedin_url and save it as factLinkedin.If factLinkedin is nullIf factLinkedin is nullYes
Change factLinkedin to blank.Change factLinkedin to blank.No
No steps
Set factConfidence to blank.Set factConfidence to blank.If wasFound is yesIf wasFound is yesYes
Change foundText to Matched.Change foundText to Matched.Trim enriched.confidence and save it as factConfidence.Trim enriched.confidence and save it as factConfidence.If factConfidence is nullIf factConfidence is nullYes
Change factConfidence to blank.Change factConfidence to blank.No
No steps
No
Change factName to blank.Change factName to blank.Change factIndustry to blank.Change factIndustry to blank.Change factEmployees to blank.Change factEmployees to blank.Change factSize to blank.Change factSize to blank.Change factFounded to blank.Change factFounded to blank.Change factHeadquarters to blank.Change factHeadquarters to blank.Change factWebsite to blank.Change factWebsite to blank.Change factLinkedin to blank.Change factLinkedin to blank.Google SheetsAdd a row to factsTab in sheetAddress.Add a row to factsTab in sheetAddress.Add 1 to lookedUp.Add 1 to lookedUp.On error
Add 1 to failedCount.Add 1 to failedCount.Show in the output: Could not look up companyName: lookupError as text.Show in the output: Could not look up companyName: lookupError as text.Set summary to Companies looked up: lookedUp as text.Set summary to Companies looked up: lookedUp as text.Change summary to summary. Already on the facts tab: skippedAlready as text.Change summary to summary. Already on the facts tab: skippedAlready as text.Change summary to summary. Skipped, the row has no company: skippedNoName as text.Change summary to summary. Skipped, the row has no company: skippedNoName as text.Change summary to summary. Lookups that failed: failedCount as text.Change summary to summary. Lookups that failed: failedCount as text.Show in the output: summary.Show in the output: summary.