---
title: Enroll existing learners to Products from a spreadsheet
description: Create a Zap that automatically enrolls paid users into products from a spreadsheet
---

[Skip to content](https://support.learnyst.com/enroll-learners-to-courses-from-google-sheets-to-learnyst#main-content)

![Learnyst Logo-25-1.png\]](https://support.learnyst.com/hs-fs/hubfs/Learnyst%20Logo-25-1.png?height=40&name=Learnyst%20Logo-25-1.png)

- [Blogs](https://blog.learnyst.com/)
- [Product Demo](https://www.learnyst.com/product-demo)
- [Help Center](https://support.learnyst.com/?__hstc=63047858.c6632626f509e3bce8daa43b7e98f888.1712298652738.1721125968223.1721135407952.38&__hssc=63047858.1.1721135407952&__hsfp=1459259341&_gl=1*1hsz3xc*_gcl_aw*R0NMLjE3MzA4OTkxMzAuQ2p3S0NBaUF4S3k1QmhCYkVpd0FZaVctLTFMeml2UU9iS3JlNDdQaXE4Y2RDRTRPbE9iZnFVYS1sYkViTm5lcW52eHljMnNXOTRoMlRCb0N3QVVRQXZEX0J3RQ..*_gcl_au*MTM5MDI5MDc5LjE3MjU5Mzg3NTIuNjU1NTcwMzYxLjE3MzMyMzMxODAuMTczMzIzMzE3OQ..)
- [Success Stories](https://www.learnyst.com/customers/success-stories)

Open main navigation

Close main navigation

- [Blogs](https://blog.learnyst.com/)
- [Product Demo](https://www.learnyst.com/product-demo)
- [Help Center](https://support.learnyst.com/?__hstc=63047858.c6632626f509e3bce8daa43b7e98f888.1712298652738.1721125968223.1721135407952.38&__hssc=63047858.1.1721135407952&__hsfp=1459259341&_gl=1*1hsz3xc*_gcl_aw*R0NMLjE3MzA4OTkxMzAuQ2p3S0NBaUF4S3k1QmhCYkVpd0FZaVctLTFMeml2UU9iS3JlNDdQaXE4Y2RDRTRPbE9iZnFVYS1sYkViTm5lcW52eHljMnNXOTRoMlRCb0N3QVVRQXZEX0J3RQ..*_gcl_au*MTM5MDI5MDc5LjE3MjU5Mzg3NTIuNjU1NTcwMzYxLjE3MzMyMzMxODAuMTczMzIzMzE3OQ..)
- [Success Stories](https://www.learnyst.com/customers/success-stories)

 Hello, how can we help you today?

- There are no suggestions because the search field is empty.

1. [Support Center](https://support.learnyst.com/?hsLang=en)
2. [Integrations](https://support.learnyst.com/integrations?hsLang=en)
3. [Zapier Integration](https://support.learnyst.com/integrations?hsLang=en#zapier-integration)

# Enroll existing learners to Products from a spreadsheet

## Create a Zap that automatically enrolls paid users into products from a spreadsheet

1. [Sign Up and Create a New Zap](https://support.learnyst.com/enroll-learners-to-courses-from-google-sheets-to-learnyst#step1)
2. [Format Your Spreadsheet](https://support.learnyst.com/enroll-learners-to-courses-from-google-sheets-to-learnyst#step2)
3. [Add the trigger application](https://support.learnyst.com/enroll-learners-to-courses-from-google-sheets-to-learnyst#step3)
4. [Add the Action Application](https://support.learnyst.com/enroll-learners-to-courses-from-google-sheets-to-learnyst#step4)

**Sign Up and Create a New Zap**

- Sign up for a Zapier account if you haven't already, and log in.
- Click on **Create Zap \> New Zap** to start building a new automated workflow.
  
  ![sheet3](https://support.learnyst.com/hs-fs/hubfs/sheet3.png?width=688&height=335&name=sheet3.png)

**Format Your Spreadsheet**

- Create a new Google Sheet and define the column headers according to these guidelines.
  
  ![course-1](https://support.learnyst.com/hs-fs/hubfs/course-1.png?width=655&height=307&name=course-1.png)
- Add a column header titled **Email** to store the user email addresses and add a valid email to test.
  
  ![course2](https://support.learnyst.com/hs-fs/hubfs/course2.png?width=655&height=307&name=course2.png)

**Add the trigger application:**

- Click on **Trigger** to set up the event that will start the Zap.
- Choose **Google Sheets** as the Trigger App.
- Choose event **New or Updated Spreadsheet Row** and click **Continue**.
  
  ![sheet4](https://support.learnyst.com/hs-fs/hubfs/sheet4.png?width=688&height=335&name=sheet4.png)
- Connect your Google account with Zapier
- Select the **Spreadsheet** and the specific sheet where you entered the column headers.
  
  ![course3](https://support.learnyst.com/hs-fs/hubfs/course3.png?width=655&height=307&name=course3.png)
- Leave the **Trigger Column** empty and click continue.
- Click on **Test Trigger** to load the most recent records from your spreadsheet.
  
  ![course4](https://support.learnyst.com/hs-fs/hubfs/course4.png?width=655&height=307&name=course4.png)
- Review the test data received and click **Continue with Selected Record**.
  
  ![course5](https://support.learnyst.com/hs-fs/hubfs/course5.png?width=655&height=307&name=course5.png)

**Add the Action Application:**

- Click on **Action** and select **Learnyst** as the action application.
- Choose the event **Paid Enrollment** to enroll the user from the spreadsheet into your Learnyst school.
  
  ![course6](https://support.learnyst.com/hs-fs/hubfs/course6.png?width=655&height=307&name=course6.png)
- In the data mapping step, map the **Email and the Course name** field with **Email and Product Title.**
  
  ![course7](https://support.learnyst.com/hs-fs/hubfs/course7.png?width=655&height=307&name=course7.png)
- Test the step by clicking **Test Step** or skip the test if you prefer.
  
  ![course8](https://support.learnyst.com/hs-fs/hubfs/course8.png?width=688&height=323&name=course8.png)
- Finally, click **Publish Zap** to make your automated workflow live.
  
  ![course9](https://support.learnyst.com/hs-fs/hubfs/course9.png?width=655&height=307&name=course9.png)

Whenever you update your spreadsheet, the Zap will automatically enroll that user into the Product.

You can navigate to **Enrollments** for your school and review the same. 

![course10](https://support.learnyst.com/hs-fs/hubfs/course10.png?width=688&height=323&name=course10.png)

 

- [Get Started](https://support.learnyst.com/get-started?hsLang=en)
- [AI Tools](https://support.learnyst.com/ai-tools?hsLang=en)
- [Courses](https://support.learnyst.com/courses?hsLang=en#main-content)

    - [Getting Started](https://support.learnyst.com/courses?hsLang=en#getting-started)
    - [Build Course](https://support.learnyst.com/courses?hsLang=en#build-course)
    - [Add Lesson](https://support.learnyst.com/courses?hsLang=en#add-lesson)
    - [Course Settings](https://support.learnyst.com/courses?hsLang=en#course-settings)
    - [Lesson Settings](https://support.learnyst.com/courses?hsLang=en#lesson-settings)
    - [Course Certificate](https://support.learnyst.com/courses?hsLang=en#course-certificate)
- [Mock test](https://support.learnyst.com/mock-test?hsLang=en#main-content)

    - [Getting Started](https://support.learnyst.com/mock-test?hsLang=en#getting-started)
    - [Build Mock Test](https://support.learnyst.com/mock-test?hsLang=en#build-mock-test)
    - [GMAT Question Types](https://support.learnyst.com/mock-test?hsLang=en#gmat-question-types)
    - [Mock test Settings](https://support.learnyst.com/mock-test?hsLang=en#mock-test-settings)
- [Test Series](https://support.learnyst.com/test-series?hsLang=en#main-content)

    - [Getting Started](https://support.learnyst.com/test-series?hsLang=en#getting-started)
    - [Build Test Series](https://support.learnyst.com/test-series?hsLang=en#build-test-series)
    - [Settings](https://support.learnyst.com/test-series?hsLang=en#settings)
- [Bundles](https://support.learnyst.com/bundles?hsLang=en#main-content)

    - [Getting Started](https://support.learnyst.com/bundles?hsLang=en#getting-started)
    - [Build Bundles](https://support.learnyst.com/bundles?hsLang=en#build-bundles)
    - [Bundle Settings](https://support.learnyst.com/bundles?hsLang=en#bundle-settings)
- [Batch](https://support.learnyst.com/batch?hsLang=en#main-content)

    - [Batch Settings](https://support.learnyst.com/batch?hsLang=en#batch-settings)
- [Track](https://support.learnyst.com/track?hsLang=en#main-content)

    - [Getting Started](https://support.learnyst.com/track?hsLang=en#getting-started)
    - [Track Settings](https://support.learnyst.com/track?hsLang=en#track-settings)
- [Ebooks](https://support.learnyst.com/ebooks?hsLang=en)
- [Podcasts](https://support.learnyst.com/podcasts?hsLang=en)
- [Webinars](https://support.learnyst.com/webinars?hsLang=en)
- [Digital/Custom Products](https://support.learnyst.com/digital-custom-products?hsLang=en)
- [Free Resource](https://support.learnyst.com/free-resource?hsLang=en)
- [1:1 Coaching](https://support.learnyst.com/11-coaching?hsLang=en)
- [1 on 1 Tutoring](https://support.learnyst.com/1-on-1-tutoring?hsLang=en)
- [Poll](https://support.learnyst.com/poll?hsLang=en)
- [Question Pool](https://support.learnyst.com/question-pool?hsLang=en#main-content)

    - [Getting Started](https://support.learnyst.com/question-pool?hsLang=en#getting-started)
    - [Build Question Pool](https://support.learnyst.com/question-pool?hsLang=en#build-question-pool)
- [Classification](https://support.learnyst.com/classification?hsLang=en#main-content)

    - [Categories](https://support.learnyst.com/classification?hsLang=en#categories)
    - [Tags](https://support.learnyst.com/classification?hsLang=en#tags)
- [Product Pricing](https://support.learnyst.com/product-pricing?hsLang=en#main-content)

    - [Getting Started](https://support.learnyst.com/product-pricing?hsLang=en#getting-started)
    - [Pricing Plans](https://support.learnyst.com/product-pricing?hsLang=en#pricing-plans)
- [Quiz & Assessment](https://support.learnyst.com/quiz-assessment?hsLang=en#main-content)

    - [Add Questions](https://support.learnyst.com/quiz-assessment?hsLang=en#add-questions)
    - [Build Quiz](https://support.learnyst.com/quiz-assessment?hsLang=en#build-quiz)
    - [Question Settings](https://support.learnyst.com/quiz-assessment?hsLang=en#question-settings)
    - [Quiz Settings](https://support.learnyst.com/quiz-assessment?hsLang=en#quiz-settings)
    - [Question Review Flow](https://support.learnyst.com/quiz-assessment?hsLang=en#question-review-flow)
- [Website](https://support.learnyst.com/website?hsLang=en#main-content)

    - [Getting Started](https://support.learnyst.com/website?hsLang=en#getting-started)
    - [Building Website](https://support.learnyst.com/website?hsLang=en#building-website)
    - [Website Navigation](https://support.learnyst.com/website?hsLang=en#website-navigation)
    - [Superpower Widgets](https://support.learnyst.com/website?hsLang=en#superpower-widgets)
    - [Sign Up Settings](https://support.learnyst.com/website?hsLang=en#sign-up-settings)
    - [Widgets (Embeddables)](https://support.learnyst.com/website?hsLang=en#widgets-embeddables)
- [Website Custom domain](https://support.learnyst.com/website-custom-domain?hsLang=en)
- [Mobile Apps](https://support.learnyst.com/mobile-apps?hsLang=en#main-content)

    - [Android](https://support.learnyst.com/mobile-apps?hsLang=en#android)
    - [iOS](https://support.learnyst.com/mobile-apps?hsLang=en#ios)
- [Communities](https://support.learnyst.com/communities?hsLang=en#main-content)

    - [Learnyst Community](https://support.learnyst.com/communities?hsLang=en#learnyst-community)
    - [Telegram Community](https://support.learnyst.com/communities?hsLang=en#telegram-community)
- [Gamification](https://support.learnyst.com/gamification?hsLang=en)
- [Learner Management](https://support.learnyst.com/learner-management?hsLang=en#main-content)

    - [Learner Profile](https://support.learnyst.com/learner-management?hsLang=en#learner-profile)
    - [Learner Actions](https://support.learnyst.com/learner-management?hsLang=en#learner-actions)
    - [Learner Settings](https://support.learnyst.com/learner-management?hsLang=en#learner-settings)
- [Roles and Permissions](https://support.learnyst.com/roles-and-permissions?hsLang=en)
- [Marketing](https://support.learnyst.com/marketing?hsLang=en#main-content)

    - [Refer Earn](https://support.learnyst.com/marketing?hsLang=en#refer-earn)
    - [Push Message](https://support.learnyst.com/marketing?hsLang=en#push-message)
    - [Marketing Email](https://support.learnyst.com/marketing?hsLang=en#marketing-email)
    - [System Email](https://support.learnyst.com/marketing?hsLang=en#system-email)
    - [Whatsapp Messenger](https://support.learnyst.com/marketing?hsLang=en#whatsapp-messenger)
    - [Workflows](https://support.learnyst.com/marketing?hsLang=en#workflows)
    - [Forms](https://support.learnyst.com/marketing?hsLang=en#forms)
    - [Campaign](https://support.learnyst.com/marketing?hsLang=en#campaign)
    - [CTA](https://support.learnyst.com/marketing?hsLang=en#cta)
    - [Promo Slider](https://support.learnyst.com/marketing?hsLang=en#promo-slider)
- [Sales](https://support.learnyst.com/sales?hsLang=en)
- [Integrations](https://support.learnyst.com/integrations?hsLang=en#main-content)

    - [Pabbly Integration](https://support.learnyst.com/integrations?hsLang=en#pabbly-integration)
    - [Zapier Integration](https://support.learnyst.com/integrations?hsLang=en#zapier-integration)
    - [Google Ads](https://support.learnyst.com/integrations?hsLang=en#google-ads)
    - [Meta Ads](https://support.learnyst.com/integrations?hsLang=en#meta-ads)
- [Newsfeed](https://support.learnyst.com/newsfeed?hsLang=en)
- [Ratings and Reviews](https://support.learnyst.com/ratings-and-reviews?hsLang=en)
- [Learner Support](https://support.learnyst.com/learner-support?hsLang=en)
- [Sub School](https://support.learnyst.com/sub-school?hsLang=en)
- [Reports](https://support.learnyst.com/reports?hsLang=en)
- [Content Security](https://support.learnyst.com/content-security?hsLang=en#main-content)

    - [CourseGaurd](https://support.learnyst.com/content-security?hsLang=en#coursegaurd)
- [School Settings](https://support.learnyst.com/school-settings?hsLang=en#main-content)

    - [General Settings](https://support.learnyst.com/school-settings?hsLang=en#general-settings)
    - [Learner Billing](https://support.learnyst.com/school-settings?hsLang=en#learner-billing)
    - [Payment gateway](https://support.learnyst.com/school-settings?hsLang=en#payment-gateway)
    - [Features](https://support.learnyst.com/school-settings?hsLang=en#features)
    - [Security](https://support.learnyst.com/school-settings?hsLang=en#security)
    - [Channels](https://support.learnyst.com/school-settings?hsLang=en#channels)
- [Zoom integration](https://support.learnyst.com/zoom-integration?hsLang=en)
- [Troubleshooting](https://support.learnyst.com/troubleshooting?hsLang=en)
- [FAQs](https://support.learnyst.com/faqs?hsLang=en)
- [Users](https://support.learnyst.com/users?hsLang=en#main-content)

    - [Learners](https://support.learnyst.com/users?hsLang=en#learners)
- [Learners' Help article](https://support.learnyst.com/learners-help-article?hsLang=en)
- [Socials](https://support.learnyst.com/socials?hsLang=en)

- [Home](https://learnyst-1.hubspotpagebuilder.net/)
- [About Us](https://learnyst-1.hubspotpagebuilder.net/about-us)
- [Contact Us](https://learnyst-1.hubspotpagebuilder.net/contact-us)
- [Blog](https://learnyst.hs-sites-na2.com/blog)

[![Chill listening crop-3](https://support.learnyst.com/hs-fs/hubfs/Learnyst%20logo%20(2).png?width=24&height=24&name=Learnyst%20logo%20(2).png "Chill listening crop-3")](https://www.learnyst.com/)

Learnyst Support

Copyright © 2026, Learnyst Insights Pvt Ltd