Capture leads, assign a unique QR coupon, and sync everything to your CRM in one flow. Great for promotions and events where each lead should get a single coupon and a clear follow up email. Teams use it to stop duplicates, keep records clean, and track coupon use.

The form collects name, surname, email, and phone. A Google Sheets lookup checks if the email already exists. If not a duplicate, the system picks the first free coupon from the sheet, gets a SuiteCRM token, creates the lead in SuiteCRM, writes the assignment back to the sheet, generates a QR code via HTTP, and sends an email. Webhook endpoints validate QR scans later. When a scan is valid, the sheet is updated to mark the coupon used, the lead in SuiteCRM is updated, and a clear OK or KO response is returned.

To set it up you need Google Sheets, SuiteCRM API access, and an SMTP email account. Map the form fields, set your SuiteCRM URL and client keys, and point the QR code to the validation webhook. Expect faster campaigns, less manual work, and reliable coupon control for giveaways, store promos, events, and lead magnets.

• Built in form trigger collects name, surname, email, and phone
• Google Sheets lookup blocks duplicate leads by email
• Coupon pick logic grabs the first unassigned code from the sheet
• SuiteCRM token and lead create calls add the contact with coupon details
• QR code generated via HTTP request and sent by SMTP email
• Validation webhook marks coupons as used and updates SuiteCRM
• Respond to webhook nodes return clear Coupon OK, No coupon, or Coupon KO

• Reduce manual coupon work from 2 hours to 5 minutes per campaign
• Automate up to 90 percent of lead entry and updates
• Cut duplicate contacts by 95 percent with sheet based email checks
• Connect Google Sheets, SuiteCRM, and email in one flow
• Track QR scans in real time and update records instantly
• Handle up to 10 times more coupon requests without extra staff

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, SuiteCRM and SMTP. See the Tools Required section above for links to create accounts with these services.
3. Prepare Google Sheets: Create a sheet with columns for COUPON, ID LEAD, EMAIL, NAME, SURNAME, PHONE, DATE, USED. Add your coupon codes with USED set to false or empty.
4. Connect Google Sheets in n8n: Open the Duplicate Lead, Get Coupon, and Update Sheet nodes. In Credential to connect with, click Create new credential and follow the prompts to add Google Sheets OAuth2. Select the document and the correct sheet.
5. Set up SuiteCRM credentials: In SuiteCRM, create an API client for client credentials. In the Token SuiteCRM nodes, set SUITECRMURL, CLIENTID, and CLIENTSECRET. Use the same values in all SuiteCRM HTTP Request nodes.
6. Map lead fields: Open the Create Lead SuiteCRM node. Confirm first name, last name, email, and phone use the Form Fields values. Adjust any custom fields if your CRM needs them.
7. Configure SMTP email: Open the Send Email node. Create a new SMTP credential with your mail host, port, username, and password. Set From, Subject, and Message. Include the QR code link or attachment returned by the Get QR node.
8. Set the validation webhook: Open the Webhook node and copy the Production URL. Use this URL in the QR code or landing page so scans hit the validation path.
9. Review duplicate logic: In the Duplicate Lead and Is Duplicate nodes, confirm the lookup checks the EMAIL column in your sheet and routes correctly.
10. Test the full path: Submit the form with a new email. Check that a lead is created in SuiteCRM, the sheet is updated with ID LEAD and coupon, and an email is delivered with the QR code.
11. Test scan validation: Open the QR link or submit a request to the validation webhook with the coupon code. Confirm the workflow returns Coupon OK, marks USED in the sheet, and updates the lead in SuiteCRM.
12. Troubleshoot: If the CRM step fails, verify the token node and Authorization header. If the sheet does not update, check sheet permissions and selected sheet tab. If email fails, confirm SMTP host, port, and auth settings.