Automatically send personalized meal plans using spreadsheets

Download the template that we've created for meal planner and use it for your needs! 

Managing nutrition plans for multiple clients? Whether you're a dietitian looking to automate meal plan delivery, a wellness coach searching for a client meal planner template, or a nutritionist tired of creating and sending plans one by one — this free template is built for you.

Built entirely in Zoho Sheet, a free spreadsheet app from Zoho's Office Suite—this template uses formulas and the Merge Template feature to automatically send personalized meal plans to every client.

Problem Statement

As a nutritionist's client list grows, the weekly prep doesn't scale with it. Creating a custom plan for each client, matching it to their goal type, and sending it out individually can easily eat up half a workday. 

This template cuts that down to a single five-minute action. Store your client details once, map their goal types to ready-made meal plans, and let Zoho Sheet send each client a personalized PDF automatically.  And since every practice works differently, the template is easy to adapt to your own goal categories and meal structure. This blog walks you through exactly how it was built.

Key Takeaways  

• Zoho Sheet's merge template delivers personalized meal plan PDFs to unlimited clients in a single send action.
• The IFS/XLOOKUP formula supports 4 goal types: High Protein, Low Carbs, Balanced Diet, Energy-Boosting.
• Each meal plan covers 7 days × 4 meals = 28 daily meal entries per client, auto-populated from goal sheets.
• Setup requires 3 sheets + 1 email template + 1 formula — no coding or third-party tools required.

Here's a quick comparison of manual vs automated meal sending planner:

 Before you begin:  

• Credits are required to use Zoho Sheet merge template feature.
• Client email addresses need to be stored in your spreadsheet before sending

 Learn how Zoho Sheet merge template credits work.

Overview 

Let's see the steps involved in creating this template:

Step 1: Add your clients' information to a sheet.

Step 2: Create a weekly meal plan based on goal types in separate sheets.

Step 3: Design a merge template to send meal plans to clients on a daily basis.

A sample output is available here — worth a quick look before starting.

Step 1: Create a sheet to store clients' information 

This is where the client information is stored.

Open a blank spreadsheet and name it Nutrition plan - Mastersheet. Add the following information manually or import it from other sources. Enter the following column headers:

• Client ID: A unique code assigned to each client for easy tracking
• Client name: The full name of the client receiving the meal plan
• Age: The client's age, which is important for tailoring nutritional recommendations
• Gender: The client's gender, which can influence dietary needs.
• Email address: The client's email address, to which the nutritionist will send meal plans.
• Goal type: The client's primary objective, such as weight loss, muscle gain, or another objective.
• Diet duration: The length of time for which the client plans to follow the meal plan.

Step 2: Create a weekly meal plan based on the goal type

This is the complete meal plan template curated for every goal type. The meal plan includes sections for each meal of the day—breakfast, lunch, dinner, and snacks for every day of the week.

1. Select the Meal Planner template from the list of publicly available templates in this page. Name it Meal planner template.

   Note: We're using a readily available template suitable for creating a meal planner in order to invest time in building other aspects of the complete automation template.

2. Add the meal plan for every day of the week and every goal type in separate sheets.

3. Rename the sheets according to goal types. Right click on the sheet name, select Tab color, and select a desired color for each sheet.

   

Step 3: Design a template to send daily meal plans to clients  

This is the email template that will be sent to clients automatically using Zoho Sheet's merge template feature.

1. Open a sheet and name it Meal planner template. Design it as shown in the image below. 

   

2. Go to Insert > Picklist > Create Picklist and add the days of the week.

   

3. Now apply automation to convert this sheet into a template. Go to Tools > Merge Template. Now your sheet will be converted to a template.

   

4. Add the source by selecting the sheet name and mapping the desired fields. Next, insert the fields next to the corresponding field name. You can either drag and drop the field or click the insert icon next to the field name.

   

5. To add the meal plan, use this formula: =IFS($C$8="High Protein";XLOOKUP(C1;'High Protein'.C2:I2;'High Protein'.C3:I6);$C$8="Low Carbs";XLOOKUP(C1;'Low Carbs'.C2:I2;'Low Carbs'.C3:I6);$C$8="Balanced Diet";XLOOKUP(C1;'Balanced Diet'.C2:I2;'Balanced Diet'.C3:I6);$C$8="Energy-Boosting Diet";XLOOKUP(C1;'Energy-Boosting Diet'.C2:I2;'Energy-Boosting Diet'.C3:I6);true;"") 

   

6. To automatically send the meal plans, run the merge action. In the Merge Template configuration box, select Email as attachment under Merge Action. Set the file type as PDF and schedule it as per your requirement. Click Preview to check your template and then click Run Merge.

   

7. In the email configuration box, provide the following details:

• File Type - PDF

• Attachment name - Name of your attachment. In this case, it can be "Meal plan".

• To - Click the [+] icon and select the email field to add recipients.

• Subject - Add an email subject. In this case, it can be "Your daily meal plan"

• Message - Add any message you want to convey to your clients.

  Once the details are added, click Run Merge. The customized email template will be sent to all your clients.

  

Conclusion 

With this setup, a nutritionist managing 50 clients can go from 12+ hours of weekly plan prep to a single 5-minute merge action — without touching a single client's plan manually.

Download the template and try it for yourself!