Purpose: Use this action to automatically log information such as registration details, student information, and class data into your spreadsheet.
Ideal For: Keeping a record of studio events, tracking enrollment numbers, and organizing dance class schedules.
Action Name:
The name of the action is set to "Create Spreadsheet Row" and identifies the operation.
Action Description:
The Create Spreadsheet Row action adds a new row of data into a specified Google Sheets spreadsheet. It’s perfect for automatically logging dance class registrations or class attendance at your studio.
Field Descriptions:
Action Name:
Mandatory: Yes
Description: Identifies what the action will do. For this action, it's "Create Spreadsheet Row".
Action:
Mandatory: Yes
Description: Defines the operation to be performed on Google Sheets. Options include creating a row, updating a cell, etc. In this instance, it is "Create Spreadsheet Row".
Choose an Account:
Mandatory: Yes
Description: Select your linked Google account (via Enrollio) that has access to the desired Google Sheet.
Drive:
Mandatory: Yes
Description: Specifies the Google Drive where the spreadsheet is located, usually "My Drive" for personal documents.
Spreadsheet:
Mandatory: Yes
Description: Choose the specific Google Sheets document where the data will be sent. For example, your studio might maintain a spreadsheet called "Dance_Class_Registrations_2023".
Worksheet:
Mandatory: Yes
Description: Select the worksheet (tab) within the spreadsheet where the new row will be inserted, such as "September Classes".
Refresh Headers:
Mandatory: No
Description: A button that updates the available columns based on the current headers in the selected worksheet. This ensures that data is mapped correctly to the columns in your dance studio records.
Starting Column:
Mandatory: Yes
Description: Specifies the starting column for the data insertion based on the sheet’s headers.
Ending Column:
Mandatory: Yes
Description: Specifies the ending column in the range you wish to populate with data.
Dynamic Fields:
Mandatory: Yes
Description: These fields represent the columns in your spreadsheet. As an example, you might have fields like "Registration ID (A)" and "Class Name (B)" to record unique identifiers and class information.
Add the Action to Your Workflow:
Drag and drop the Google Sheets action into your desired workflow within Enrollio.
Select Action Type:
Choose "Create Spreadsheet Row" from the action dropdown to add a new row to your dance class record.
Choose Google Account:
Select the linked Google account that grants you access to your studio’s Google Sheets.
Select Drive:
Typically choose "My Drive" unless you are using a shared drive for your studio.
Select Spreadsheet and Worksheet:
Pick the correct Google Sheets document (e.g., "Dance_Class_Registrations_2023") and the corresponding worksheet (e.g., "September Classes") where the new data should be added.
Map Data Fields:
Use the Starting Column and Ending Column to determine the range. Map each piece of workflow data to the appropriate column in the Google Sheet—such as mapping a new student's registration detail to "Registration ID" and the class they registered for to "Class Name".
Refresh Headers:
If any changes have been made to the headers on your spreadsheet, click this option to ensure all data aligns correctly.
Imagine you run a children’s dance studio and want to automate class registration records. Here's how you can set it up:
Trigger:
New Dance Class Registration Received.
Condition:
A registration form is submitted online by a parent.
Action (Google Sheets - Create Spreadsheet Row):
Drive: My Drive
Spreadsheet: "Dance_Class_Registrations_2023"
Worksheet: "September Classes"
Starting Column: Registration ID (A)
Ending Column: Class Name (B)
Data Mapping:
Registration ID: Automatically insert the unique registration ID.
Class Name: Automatically insert the class selected by the parent (e.g., Ballet Basics, Hip Hop Groove).
By integrating the Google Sheets action within your workflows in Enrollio, you can automate enrollment tracking, reduce manual data entry, and keep your studio’s records up-to-date with minimal effort.
This integration helps your dance studio focus on what you do best—teaching and inspiring young dancers—while Enrollio takes care of efficient data management.
