Turn every new registration into a complete attendee onboarding flow. Great for event teams that need to welcome people fast, keep data clean, and get guests into the right sessions and channels without manual steps.

When a Typeform submission arrives, the data is saved to Google Sheets. A Mattermost user account is created with the attendee name and email, then the user is invited to the team. Session choices are split into separate rows so each selection can be handled on its own. The flow pulls session details from a Sessions sheet, merges them by the Session name, and picks up the right Mattermost channel IDs and Google Calendar event IDs. The user is added to the matching Mattermost channels, the related Google Calendar events are updated with the attendee, and a Gmail welcome message is sent.

You will need a Typeform form, a Google Sheet with Attendees and Sessions tabs, a Mattermost team with channels listed in the Sessions sheet, a Google Calendar with session events, and a Gmail account. Expect faster onboarding, fewer errors, and better show rates. Good fits include webinars, workshops, training sessions, and hackathons.

• Typeform trigger captures each new registration instantly.
• Google Sheets append logs attendee data to the Attendees tab for tracking.
• Mattermost account creation and team invite set up access for each registrant.
• Session choices are expanded into separate rows for precise processing.
• Session details are pulled from the Sessions sheet to get IDs and metadata.
• Data is merged by the Session field to match each choice with the right info.
• Attendees are added to the correct Mattermost channels based on their sessions.
• Google Calendar events are updated to include the attendee.
• A personalized Gmail welcome email confirms access and next steps.

• Reduce manual onboarding from 15 minutes to 1 minute per attendee
• Streamline cross tool updates by about 80% with one flow
• Improve data accuracy by mapping sessions to channels and events, cutting copy paste errors by 90%
• Handle high signup volume without extra staff time
• Connect Typeform, Google Sheets, Mattermost, Google Calendar, and Gmail in one place

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 Typeform, Google Sheets, Mattermost, Google Calendar and Gmail. See the Tools Required section above for links to create accounts with these services.
3. In n8n Cloud, open the Typeform Trigger node. In the Credential to connect with field, click Create new credential and follow the on screen steps to connect your Typeform account. Select the form you want to use or paste the form ID.
4. Open both Google Sheets nodes. For each, click Create new credential in the credentials field and connect using Google OAuth2. Set the spreadsheet ID. Confirm the ranges Attendees!A:F and Sessions!A:F match your sheet tabs and columns.
5. Open the Mattermost nodes Create Account, Add to team, and Add to channels. For each, create or select a Mattermost credential. In Add to team, confirm the team ID is correct. In Add to channels, ensure your Sessions sheet provides the correct Mattermost Channel ID for each session.
6. Open the Function node labeled Array to Rows. Verify the field names match your Typeform question labels for name, email, and session choices. Keep the Session field name consistent with the Sessions sheet.
7. Open the Merge Data node. Confirm mode is mergeByKey and both properties are set to Session so session choices match the right row from the Sessions sheet.
8. Open the Google Calendar node. Create a Google Calendar credential if needed using OAuth2. Set the calendar ID. Confirm the Event ID field uses the Google Calendar Event ID from the merged data.
9. Open the Gmail node. Create a Gmail OAuth2 credential. Write a clear subject and body. Use the attendee name and session data with expression fields to personalize the message.
10. Submit a test response in your Typeform. Check Google Sheets for a new row in Attendees. Confirm a Mattermost user is created, invited to the team, and added to the right channels.
11. Check Google Calendar to see the attendee added to the related events. Verify the Gmail welcome email arrives in the test inbox.
12. Troubleshoot common issues: if channels are not assigned, confirm the Session text in Typeform exactly matches the Session column in the Sessions sheet. If events do not update, confirm calendar permissions and event IDs. If emails fail, check Gmail sending limits and credential status.