The Scenario
You run community for a developer tools startup. Your beta launched three months ago and you have 500 early user emails in an Excel workbook — the UserEmails table, one email per row in column A. Your growth lead asked you to build a Twitter engagement list so the company can follow active developers, amplify their posts, and build social credibility before the public launch. The problem: you have 500 emails and zero Twitter handles.
The bad version:
- Search each email address in Twitter's search — which returns nothing useful because Twitter doesn't index by email address publicly
- Cross-reference your email list against the company's Twitter followers manually — tedious, only catches people who already follow you, and leaves out the 80% who don't
- Ask your developer to build a script that calls both the Twitter API and Datagma together, handles OAuth on both sides, manages rate limits, and writes the results back into the workbook — that's a whole afternoon for what should be a one-column enrichment
Your community strategy meeting is tomorrow morning and the growth lead expects a starter list.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the UserEmails table, understands the layout, and through its built-in Datagma integration it calls the email-to-Twitter lookup endpoint for each row and writes the matched handle into the TwitterHandle column. No script, no API wiring, no manual search.
In Excel, read the UserEmails table and for each row call Datagma GetTwitterByEmail, then fill in the TwitterHandle column with the result
What You Get
- TwitterHandle column: Twitter username for each email where Datagma found a match
- Rows where Datagma found no Twitter account are left blank — your engagement list only contains handles you can actually use
- The output is importable directly into a Twitter list manager or social scheduling tool without reformatting
What If the Data Is Not Quite Ready
The email list has duplicates from multiple signup sources
Your beta ran across two acquisition channels and you have around 60 duplicate emails in the table.
Deduplicate the UserEmails table by email address, then use Datagma to look up the Twitter handle for each unique email and fill the TwitterHandle column with the result
You want to only surface handles with public accounts
Some lookups will return handles that belong to private or inactive accounts. Before you build a follow list, you want to filter those out.
Look up Twitter handles for all emails in the UserEmails table using Datagma, fill the TwitterHandle column, then add a note in an AccountStatus column for any handle that appears to belong to a private or inactive account based on Datagma's confidence signal
You want to enrich further with follower count
Your growth lead wants to know who has an audience worth amplifying before you build the engagement list.
For each email in the UserEmails table, use Datagma to find the associated Twitter handle and fill the TwitterHandle column, then enrich each found handle with follower count into a FollowerCount column and flag in an ActivityStatus column if the account appears inactive
Full dedup, lookup, and engagement-ready export in one pass
You have duplicate emails, you want only verified active accounts, and you need the final output in a separate worksheet your growth lead can import directly.
Deduplicate the UserEmails table by email, run Datagma email-to-Twitter lookup for each unique address, fill the TwitterHandle column, flag rows where no match was found or the account appears inactive, then copy only the rows with confirmed handles into a new worksheet called 'TwitterEngagementList'
Try It
If your user email list is in an Excel workbook with no social data attached, get the 7-day free trial of SheetXAI and open it. Ask it to map your emails to Twitter handles using Datagma and you'll have an engagement-ready list without writing a single line of code. For related workflows, see bulk-enrich a lead list or detect job changes.