Clean and format raw form data for database syncs

Creates exact formatting, casing, and normalization rules to prevent corrupted contact records and messy syncs.

Prompt

Prompt
Act as a revenue operations data architect. Review the pasted form submission fields and provide complete data cleaning and transformation rules to prepare the data for database ingestion.

Rules:
- Define strict normalization rules for casing, phone numbers, website URLs, and empty fields.
- Provide fallback values for missing optional fields so sync operations never fail on null values.
- Detail validation checks that flag invalid emails or junk entries before writing to the database.

Output format:
Provide a markdown table with these exact columns: Field Name, Input Example, Transformation Rule, Cleaned Output Example, and Fallback Value.
Conclude with a short bullet list of three critical rejection criteria for junk submissions.

Here are the form fields and raw sample data:

Example output

Example for: B2B inbound demo request form

Field NameInput ExampleTransformation RuleCleaned Output ExampleFallback Value
First NamejANETrim spaces, capitalize first letter, lowercase remainderJaneUnknown
Company EmailJane@AcmeCorp.comTrim spaces, force all characters to lowercasejane@acmecorp.comREJECT_ROW
Phone Number(555) 019-2834 ext 2Strip non-numeric characters except leading +, format to E.164 standard+15550192834Null
Websitewww.acme.com/homeStrip query strings and paths, prepend https://, lowercase domainhttps://acme.comNull
Company Size[Blank]Trim, map to predefined CRM tier picklist1-10 employeesNot Specified
Critical Rejection Criteria
  • Disposable or temporary email domains (such as mailinator or tempmail).
  • Phone number contains fewer than 7 digits after stripping non-numeric characters.
  • First or Last Name contains test strings such as asdf, test, or n/a.
Written by AI from this prompt. Your results will vary.

Paste your list of form fields and sample raw inputs directly below the prompt in ChatGPT, Claude, or Gemini. If you use a specific tool like Zapier or Make, ask the model to provide the exact formatting formulas next.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Automation & Workflows