Common Issues and Troubleshooting
This guide covers solutions for the most common questions and problems you may run into while using TexAu.
Import Failures
Issue: "File is too large to import"
Description: Your CSV exceeded the file size limit.
Causes:
- Your file is larger than 10MB
- The file contains unnecessary columns that inflate its size
- The file format is not actually CSV (it is Excel, Google Sheets export, etc.)
Solution:
-
Check your file size: Right-click the file and check its properties. If it is over 10MB, break it into smaller chunks.
-
Split your data:
-
Open your file in Excel, Google Sheets, or a text editor
-
Split the data into smaller files (5-8MB each).
-
Save each as a separate CSV.
-
Import them one at a time into TexAu
-
-
Reduce file bloat:
-
Remove unnecessary columns you do not need enriched
-
Delete blank rows
-
Remove duplicate entries
-
-
Save as CSV: Export as standard "CSV (Comma-delimited)".
Issue: "Too many columns detected"
Description: Your file has more than 100 columns.
Solution:
- Keep only what you need: You do not have to enrich every column. Remove columns you will not need.
- Import in batches: Split your columns across multiple imports if necessary.
- Contact support: Contact support if you need more than 100 columns.
Issue: "Unrecognized file format"
Description: Unrecognized file format.
Causes:
- File is Excel (.xlsx, .xls) instead of CSV
- File is a Google Sheets link (not downloaded as CSV)
- File is JSON, XML, or another format
- File extension is wrong (named .csv but actually a different format)
Solution:
-
Convert to CSV:
-
Excel: File > Save As > CSV (Comma-delimited).
-
Google Sheets: File > Download > CSV.
-
JSON/XML: Convert to CSV first.
-
-
Check the file extension: Make sure your file actually ends in
.csv -
Open the file in a text editor: If you are unsure what format it really is, open it in Notepad or a code editor to see the actual contents.
Issue: "Encoding error detected" or "Special characters garbled"
Description: Invalid character encoding (often due to special characters or locale settings).
Causes:
- File was created in a non-English locale (European, Asian, etc.)
- File uses UTF-16 instead of UTF-8
- File contains characters TexAu cannot process
Solution:
-
Re-save your file in UTF-8:
-
Open in a text editor (Notepad++, VS Code).
-
Go to File > Encoding > UTF-8.
-
Save the file
-
Try importing again
-
-
Clean up special characters: If you have symbols or emojis, remove them and use standard letters/numbers instead.
-
Use a different tool first:
-
Open the file in Excel
-
Copy all data
-
Paste into Google Sheets
-
Download as CSV from Google Sheets
-
This resolves most encoding conflicts.
-
Issue: "Binary file detected, cannot import"
Description: TexAu detected a binary/executable instead of a text data file.
Causes:
- You accidentally uploaded the wrong file
- Your CSV is corrupted or saved in binary format
- Your file name looks like data but the file is actually something else
Solution:
-
Double-check your file: Make sure you are uploading the CSV and not a
.exe,.dll, or other program file. -
Re-save the CSV:
-
Open your CSV in Excel or Google Sheets
-
Verify data visibility.
-
Save/download it as CSV format again
-
Try importing the new version
-
-
Ask for help: If you are not sure what went wrong, reach out to support with the file.
Enrichment Not Running
Issue: "Enrichment is pending but has not started"
Description: Enrichment submitted but not started.
Causes:
- Missing required columns in your table
- No data provider is configured for the columns you want enriched
- Your account is out of enrichment credits
- The enrichment is actually running but waiting in a queue
Diagnosis:
-
Check for required columns:
-
Go to your table
-
Look at the columns you want enriched
-
Make sure each has a data type assigned (Email, Company Name, Phone, etc.)
-
Enrichment requires assigned column data types.
-
-
Verify providers are set up:
-
Click the target column.
-
Check the "Waterfall" or "Data Source" section
-
Make sure at least one provider is selected and connected
-
If empty, connect providers first.
-
-
Check your credits:
-
Click profile menu (top right).
-
Go to "Billing and Usage"
-
Look at your remaining credits
-
If zero, top up or upgrade.
-
Solution:
- No credits? Add a payment method and purchase credits, or upgrade to a paid plan.
- No providers? Go to Settings, then Integrations, and connect the data sources you need.
- Wrong data type? Edit your column and assign the correct semantic type.
Issue: "Enrichment failed" or "Error during processing"
Description: Enrichment started but encountered an error.
Causes:
- Input data is malformed or incomplete
- A provider is temporarily unavailable
- The enrichment took too long and timed out
- Network connection was interrupted
Solution:
-
Check your input data:
-
Look at the cells that failed
-
Make sure they contain valid data (complete email addresses, proper phone numbers, real company names)
-
Remove malformed cells and retry.
-
-
Try enriching a smaller batch:
-
Select just 10 to 20 rows
-
Run the enrichment
-
If successful, check remaining data quality.
-
-
Wait and retry:
-
Providers can be temporarily down.
-
Wait 5 to 10 minutes
-
Click enrichment to retry.
-
-
Check your internet connection: Make sure you have a stable connection to TexAu.
Enrichment Returning Empty Results
Issue: "No data found" or all results are blank
Description: Enrichment returned empty cells.
Causes:
- All waterfall providers failed (data not found in databases).
- Your input data is incomplete or malformed
- All the providers you are using are having temporary issues
- The data you are looking for genuinely does not exist
Diagnosis:
-
Check a single cell manually:
-
Look at a row that returned no data
-
Review the input (email, company name, phone number, etc.)
-
Ask yourself: "Is this realistic data?"
-
Search manually to verify if data exists.
-
-
Review your waterfall:
-
Which providers are you using?
-
Are they the right ones for this type of data?
-
Do you have multiple providers as backups?
-
-
Check provider status:
-
Go to Settings, then Integrations
-
Make sure all your providers show as "Connected"
-
If one shows an error, there might be an authentication issue
-
Solution:
-
Improve input data quality:
-
Remove incomplete entries (emails missing @, phone numbers wrong length, etc.)
-
Validate company names against your CRM
-
Use a data cleaning step before importing
-
-
Add more providers to your waterfall:
-
If you are only using one provider, add backups
-
Databases vary by provider.
-
More providers increase match rates.
-
-
Check your formula: Ensure formulas handle empty cells (use IF or COALESCE).
-
Accept that some data will not be found: A 70-80% enrichment rate is standard.
Real-Time Updates Not Appearing
Issue: "Results are not showing up in real time" or "I need to refresh to see new data"
Description: Live browser updates are not displaying.
Causes:
- Browser connection dropped (network interruption)
- Unsupported or outdated browser.
- Pop-up blockers or security software interfering
- Browser tab is throttled in the background.
Solution:
-
Refresh your browser:
-
Press Ctrl+R or Cmd+R.
-
This reconnects and refreshes the table.
-
-
Check your browser:
-
Use Chrome, Firefox, Safari, or Edge.
-
Use a modern browser.
-
-
Disable browser extensions:
-
Extensions like ad blockers or VPNs can interfere
-
Disable them temporarily and refresh.
-
-
Check your internet connection:
-
Are you on a stable Wi-Fi or wired connection?
-
If on mobile data, try moving to Wi-Fi
-
Weak connections cause dropouts.
-
-
Keep the tab active:
-
Browsers throttle background tabs.
-
Focus the TexAu tab.
-
-
Try a different browser: If the issue persists, test in Chrome or Firefox to see if it is browser-specific.
Webhook Delivery Failures
Issue: "Webhook failed to deliver" or "Destination URL unreachable"
Description: Webhook delivery failed.
Causes:
- The destination URL is wrong or no longer exists
- The destination server is down or not accepting requests
- Firewall or security rules are blocking the connection
- Authentication credentials are invalid
Diagnosis:
-
Test the URL:
-
Copy your webhook URL
-
Paste it into a browser address bar
-
If 404 or server error occurs, the endpoint is invalid.
-
-
Check authentication:
-
Go to your webhook settings
-
Review your API key or token
-
Verify token validity.
-
Regenerate it if needed
-
-
Review the destination service:
-
Is it actually running?
-
Has the API changed recently?
-
Are there firewall rules blocking incoming webhooks?
-
Solution:
-
Update the URL:
-
Verify webhook URL spelling.
-
Ensure it is the correct endpoint.
-
-
Re-authenticate:
-
Generate a new API key from the destination service
-
Update webhook settings.
-
Test the webhook again
-
-
Ask the destination service provider:
-
If you are sending to another app, contact their support
-
Confirm webhook support and format.
-
-
Understand retry behavior:
-
TexAu retries failed webhooks automatically.
-
Webhooks pause after multiple failures.
-
A notification will alert you to fix it.
-
Issue: "Payload too large" or "Request rejected"
Description: Webhook payload exceeded recipient size limits.
Solution:
-
Send less data per webhook:
-
You might be sending too many columns
-
Or sending too many rows at once
-
Try reducing what you include in the webhook
-
-
Check the destination's limits:
-
Different services have different payload size limits
-
Zapier, Make.com, and similar platforms usually accept up to 5 to 10MB
-
Direct endpoints might be more restrictive
-
Check the destination's API documentation
-
-
Format the data before sending:
-
Select only the required fields.
-
This reduces payload sizes.
-
Formula Errors
Issue: "Formula syntax error" or "Invalid formula"
Description: Formula syntax is invalid.
Common mistakes:
-
Missing parentheses:
-
Wrong:
IF A1 = "test", "yes", "no" -
Right:
IF(A1 = "test", "yes", "no")
-
-
Wrong operators:
-
Wrong:
IF A1 = test(test should be quoted) -
Right:
IF(A1 = "test")
-
-
Referencing non-existent columns:
-
Column names are case-sensitive.
-
Use column selector to prevent typos.
-
-
Mixing column names and letters:
-
Wrong:
SUM(A1, B2, C3)(do not use letter cell coordinates) -
Right:
SUM(Company_Revenue, Additional_Income)
-
Solution:
- Check the error message: Click the error icon to view details.
- Use the formula builder: Use the visual formula builder to prevent syntax errors.
- Test with sample data: Test your formula on a single row first.
- Start simple: Build incrementally (e.g. test basic IF before nesting).
Issue: "Referencing a column that does not exist"
Description: Formula references a missing column.
Solution:
- Check spelling: Column names are case-sensitive.
- Use the column dropdown: Select columns from the dropdown menu to avoid errors.
- Check for spaces: Quote columns with spaces (e.g.,
"First Name"). - Verify the column exists: Verify the column exists in the table.
Issue: "Type mismatch error" or "Cannot compare text and number"
Description: Formula compares incompatible data types (e.g., text vs number).
Solution:
-
Check your data types:
-
Check column semantic data types.
-
Number columns cannot be compared directly to text.
-
-
Convert the data:
-
Use TEXT() to cast numbers to text.
-
Use VALUE() to cast text to numbers.
-
Example:
IF(VALUE(Age) > 21, "adult", "minor")
-
-
Match data types in comparisons:
-
Compare text to text
-
Compare numbers to numbers
-
Use conversion functions if needed
-
Issue: "Division by zero error"
Description: Formula divided by zero or an empty cell.
Solution:
-
Use IF to check before dividing:
IF(Denominator = 0, 0, Numerator / Denominator) -
Use COALESCE for empty cells:
IF(COALESCE(Denominator, 0) = 0, 0, Numerator / COALESCE(Denominator, 0)) -
Review your input data: Verify the denominator column contains numbers and is not empty.
Scheduled Job Not Running
Issue: "My scheduled enrichment did not run at the expected time"
Description: Scheduled job did not run.
Causes:
- The schedule is paused
- Your timezone setting is wrong (so it ran at a different time)
- The table has no new data to enrich
Diagnosis:
-
Check if the schedule is paused:
-
Go to your table
-
Click "Schedules" or "Automation"
-
Look for your scheduled enrichment
-
Is it toggled ON or OFF?
-
-
Check the schedule time:
-
Click on the schedule to edit it
-
Verify the time is correct
-
Check your timezone setting
-
-
Check for new data:
-
"Enrich new rows" schedules won't run if all rows are already enriched.
-
If all rows are processed, the run is skipped.
-
Solution:
-
Toggle the schedule ON: Make sure it is not paused.
-
Correct your timezone:
-
Open schedule settings.
-
Verify and set your timezone.
-
Save and verify scheduled time.
-
-
Add more data: Add new data or flag rows for re-enrichment.
Integration Connection Issues
Issue: "Integration disconnected" or "API key expired"
Description: Integration connection lost.
Causes:
- Your API key, token, or password expired
- The service revoked your access
- You changed your password on the external service but did not update it in TexAu
- The external service changed their authentication requirements
Solution:
-
Reconnect the integration:
-
Go to Settings, then Integrations
-
Find the disconnected service
-
Click "Reconnect" or "Remove and Re-add"
-
-
Re-authenticate:
-
Sign in to the external service (Salesforce, HubSpot, Slack, etc.)
-
If you used OAuth (a login button), click it again
-
If you used an API key, generate a fresh one and paste it into TexAu
-
-
Check permissions:
-
Make sure your account has permission to generate API keys
-
Ask your admin if you do not have access
-
-
Contact the service provider:
-
If you still cannot connect, reach out to their support
-
They might have changed their API or paused your account
-
Issue: "Permissions error" or "Access denied"
Description: Connected integration permissions error.
Solution:
-
Ask your admin:
-
Shared accounts require admin permissions.
-
Admin access may be required to generate API keys.
-
-
Create a dedicated service account:
-
Use a service account with appropriate access permissions.
-
Use that account's API key in TexAu
-
-
Review your plan:
-
Verify API endpoints are supported on your provider's plan.
-
Upgrade if necessary
-
Slow Performance
Issue: "TexAu is running slowly" or "Enrichment is taking a long time"
Description: Enrichment latency is higher than expected.
Causes:
- Your table is very large (100,000+ rows)
- You are running too many enrichments at the same time
- Your formulas are complex
- Network latency to data providers is high
How to optimize:
-
Reduce table size:
-
Enrich in smaller batches (e.g. 10,000 rows).
-
Batch your enrichments
-
Archive old data you do not need
-
-
Limit concurrent enrichments:
-
Only run one enrichment at a time
-
Avoid concurrent overlapping runs.
-
-
Simplify formulas:
-
Split complex formulas into simpler columns.
-
Example: Instead of one deeply nested formula, use multiple columns with simpler formulas
-
-
Use faster data providers:
- Some providers respond faster than others.
- Reorder your waterfall to try faster providers first.
-
Check your internet connection:
- Weak connections cause slowness.
- Move closer to your router or use a wired connection.
-
Use off-peak hours:
- Schedule large enrichments for evenings or weekends.
- Your data processes faster when the system is less busy.
-
Contact support: If nothing helps and your table is critical, let us know.
Still Stuck?
If you cannot find your issue above, reach out to support with:
- Workflow description
- Error screenshots
- Table name and start time
- Attempted troubleshooting steps
Our team usually responds within a few hours.