Best Of

The only thing I can really see doing here is adding the "Sheet" reference column to see what sheet the column is coming from, so you can go rename that column. Then all reports that are connected to that column will update with the new column name.

However unfortunately there is currently not a way to identify what reports a sheet is connected to. That is a request in the community pages to have a tab on the side of a sheet that shows what reports the sheet is used in. As far as I know it is not voted up high enough yet to be part of the roadmap.

Good afternoon Sir/Madam,

I found out the issue why my clients are not getting my automation emails. I have enabled custom domain and the problem is as follow and I'm wondering if there is a fix for it:

• There is a list of 150 rows of data and some of these rows have the same contact (email). Once a field is trigger to send automation, it appears that the email was combined with ALL of the information within 1 email. This can make the email super long as our text is already enough for 1 email. I believe this is why my email never get to the client. Is there a way for these email to be separate from each other and not combined?

thank you.

Thank you @Isis Taylor

@Joe Mul You can accomplish this by using the Current User filter in the report builder.

Workflows are an amazing tool to automate manual tasks! To set up an automation to the students individual email when a status is changed, please see below:

Step 1: Ensure Your Sheet is Set Up Correctly

1. Verify Columns:
   • Student Email: Contains each student’s email address.
   • Status: Tracks the status for each student (e.g., "Pending," "Accepted," "Rejected").
   • Trigger Column (Optional): If needed, create a helper column to further refine when an email is sent.

Step 2: Create an Automation Rule

1. Open your sheet and go to Automation in the top menu bar.
2. Select Create a Workflow or Manage Workflows.
3. Choose Custom Workflow.

Step 3: Configure the Trigger

1. In the automation editor, select Trigger.
   • Choose When rows are changed.
   • Set it to trigger when the Status column is updated.

Step 4: Set Conditions (Optional)

1. Add conditions to filter which rows trigger the email:
   • For example, "Status is 'Accepted'" or "Status changes from 'Pending' to 'Rejected'."
   • Click + Condition to specify these filters.

Step 5: Add the Action

1. Under Action, select Alert Someone or Request an Update (for more interactive emails).
2. In the Recipient field:
   • Choose the column containing student emails (e.g., [Student Email]).
3. Customize the email content:
   • Add dynamic fields using placeholders (e.g., “Dear {Student Name}, your status has changed to {Status}.”).
   • Include additional details if needed, like deadlines or next steps.

Step 6: Test the Workflow

1. Manually change the status for a test row to ensure the email is sent correctly.
2. Verify the email content and formatting in the student's inbox.

Step 7: Save and Activate

1. Click Save to finalize the workflow.
2. Ensure the workflow is toggled ON to activate it.

Please let me know if this helped you out!

Thank you,