Google Sheets and Datagma

Google Sheets

Triggers

• Google Sheets New RowTriggers when a new row is added to a Google Sheets spreadsheet.

Actions

• Append rowAppend a single row to the end of a Google Sheet.
• Create spreadsheetCreate a new Google Sheets spreadsheet.
• Delete spreadsheetDelete a Google Sheets spreadsheet permanently.
• Write rowOverwrite a whole row, from column A, with values in column order. To change only some cells of a row, use Update row.
• Update rowSet some cells of one row by column name, leaving the rest of the row as it is. Pair it with Read rows to write a result back to the row it came from. A column that doesn't exist yet is added to the header row.
• Clear row valuesClear values in a specific row without deleting the row itself.

Datagma

Actions

• Enrich a personLook one person up from their LinkedIn profile URL or their work email address, and get back their job title, employer, location and, when you ask for them, their verified work email, their mobile number and their full LinkedIn history. Use this to fill in a lead from a form submission or a CRM record. If all you have is a name, use 'Enrich a person by name'.
• Enrich a person by nameLook one person up from their full name and the company they work at, and get back their job title, LinkedIn profile, location and, when you ask for them, their verified work email, their mobile number and their full LinkedIn history. Datagma searches for somebody inside a company, so both the name and the company are needed. Use this to work through a list of names, or a CRM export with no email addresses.
• Enrich a companyLook one company up from its domain, LinkedIn page, name or French SIREN and get back its headcount, industry, headquarters, website and founding year, plus, on request, its funding rounds and revenue band, or its entry in the French company register. Use this to qualify inbound signups or to score an account list.
• Find a work emailFind and verify someone's work email address from their name and their company. Datagma checks the mailbox before answering, so a returned address is confirmed rather than guessed, except on a domain that accepts all mail, where it returns its best guess and flags it (and does not charge for it). Use this to complete a lead list before a campaign.
• Check whether a contact changed jobsCheck whether someone still works at the company you have on file. Datagma looks up their current employer and answers with a plain 'changed jobs' true or false, plus where they are now. Use this to keep a CRM clean, or to spot a champion who has moved somewhere worth following them to. Coverage is strongest in France, Spain, Italy and Germany.
• Look up who owns a phone numberFind the person behind a phone number: their name and, when Datagma has it, their LinkedIn profile. Use this to put a name to a missed call or an inbound number before you call back.