Turn new form signups into clean leads in your CRM and send each person a unique coupon. Great for landing pages, paid ads, and newsletter opt ins where a code or gift drives conversion.

Signups enter through a built in n8n form or a webhook. Fields are mapped into a clean record. A Google Sheets lookup checks if the email already exists. If it is a duplicate, the flow returns a KO response. If not, the sheet provides the first free coupon. The workflow requests a token from SuiteCRM using client credentials, creates the lead with the coupon attached, then writes the lead ID back to the sheet to mark the coupon as used. A simple JSON OK response confirms success.

Setup needs a Google Sheet with a COUPON column and an ID LEAD column for tracking. In SuiteCRM, add a lead field named coupon so the code is stored with the contact. Expect faster lead intake, no double codes, and clear tracking across tools. Use this for promo offers, eBooks, webinars, or any gated content that needs one time codes and direct CRM entry.

• Two intake options: built in form trigger or generic webhook endpoint
• Field mapping with a Set node to keep names, email, and other data consistent
• Duplicate check in Google Sheets by matching the email column
• Coupon selection from Google Sheets that finds the first unused code
• SuiteCRM token request using client credentials for secure API calls
• Lead creation in SuiteCRM with the coupon stored on the lead record
• Sheet update that stamps the used coupon row with the new lead ID

• Reduce manual lead entry from 1 hour to 5 minutes per campaign
• Eliminate 95% of duplicate signups with a live email check
• Improve code accuracy by assigning one unique coupon per lead
• Connect Google Sheets and SuiteCRM without custom code
• Handle 5 times more submissions during peak campaigns

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets and SuiteCRM. See the Tools Required section above for links to create accounts with these services.
3. Create a Google Sheet with at least two columns: COUPON and ID LEAD. Put all your coupon codes in the COUPON column. Leave ID LEAD empty for unused codes.
4. In the n8n credentials manager, create Google Sheets OAuth2 credentials. Then open each Google Sheets node and choose your Google Sheets credential. Select your document and the correct sheet tab.
5. Open the Token SuiteCRM node. Replace SUITECRMURL with your SuiteCRM base URL. Enter your client_id and client_secret from your SuiteCRM OAuth2 Client Credentials setup.
6. In SuiteCRM, add a lead field named coupon so the API can store the code with the new lead.
7. Open the Create Lead SuiteCRM node. Confirm the Authorization header uses the access_token from the Token SuiteCRM node. Check the JSON body to ensure first name, last name, email, and coupon map from the Set node fields.
8. Open the Update Lead Google Sheets node. Map the row update so the selected coupon gets the new lead ID in the ID LEAD column.
9. Choose your intake: use the On form submission trigger and set the fields you want, or connect an external form to the Webhook URL. If using an external form, return the OK or KO nodes as the response path.
10. Test once with a brand new email. Submit the form. You should get a JSON OK message, see a new lead in SuiteCRM, and see the coupon row updated with the lead ID in Google Sheets.
11. Test again with the same email to confirm the duplicate check. You should receive a JSON KO message and no new lead should be created.
12. Troubleshoot: if you get 401 errors from SuiteCRM, recheck SUITECRMURL, client_id, and client_secret. If Sheets fails to update, verify OAuth permissions and the selected sheet tab.