N8N Workflow to Clone a Google Sheet with Required Formatting

I need an n8n workflow that picks up every new or updated row in a source Google Sheet, reformats specific columns, then writes the cleaned data to a target Google Sheet.

Mandatory transformations
• Dates arriving in any form must be converted to the MM/DD/YYYY layout before they land in the destination sheet.
• Inside text fields, remove spaces and strip out special characters (punctuation, symbols, emojis). The final string should contain only the original letters and numbers—no extra spacing or symbols.

I’ll provide sample source and destination spreadsheets, point out which columns hold dates and which hold free-text, and share access credentials via a service account. The flow should be easy for me to extend, so use clear node names, add brief comments, and include one example of each transformation directly inside the workflow.

Deliverables
1. .json export of the complete n8n workflow.
2. Short read-me explaining where to paste spreadsheet IDs, how to add or change columns, and how to import the flow into any self-hosted or cloud n8n instance.

I’ll test by inserting five mixed rows; once they appear perfectly formatted in the second sheet, the job is done.