Update Macros Goals Zapier Action

With Exercise.com’s fitness business management software, you can automate workflows by integrating with Zapier. This guide shows you how to incorporate user macros into the Update User action so that nutrition goals update automatically for your clients.

1. Configure the Spreadsheet

Set up the spreadsheet that will store client macros. In this example, you’ll use Google Sheets.

2. Create a New Spreadsheet

Create a new blank spreadsheet or select an existing one you want to use.

3. Prepare the Spreadsheet

Add the variables needed to update a client: Client ID and the required macros.

4. Log Into Zapier

Log into your Zapier account to start creating automations.

5. Create a New Zap

Click Create to make a new Zap.

6. Select Zaps

Select Zaps from your dashboard.

7. Choose the Trigger Event

Choose the event that will start the Zap.

8. Select the Spreadsheet App

Select your spreadsheet app. This example uses Google Sheets.

9. Set the Trigger

Choose the trigger event: New or Updated Spreadsheet Row.

10. Connect Your Exercise.com Account

Select your Exercise.com account if prompted, then click Continue.

11. Choose the Spreadsheet

Select the spreadsheet you prepared earlier.

12. Choose the Worksheet

Select the worksheet that contains your data.

13. Select the Trigger Column

Pick the column Zapier should watch for changes. Selecting the first variable is often simplest.

14. Continue

Click Continue to proceed.

15. Test the Trigger

Click Test Trigger so Zapier can pull in sample data.

16. Choose a Sample Row

Select the row you want to use for testing, then click Continue with the selected record.

17. Select Exercise.com (Version 3.1.0)

Add an Action step and choose Exercise.com (Version 3.1.0).

18. Choose the Action: Update Client’s Nutrition Goals

Select the action event Update Client’s Nutrition Goals.

19. Connect Your Exercise.com Account

Select your Exercise.com account to authenticate the action step.

20. Continue

Click Continue to map your fields.

21. Map the Fields

Map the spreadsheet columns (Client ID and macro fields) to the matching fields in the Exercise.com action. Click Continue when done.

22. Test and Publish the Zap

Send a test to confirm the update works as expected. If everything looks good, click Publish.

23. Open Clients in Exercise.com

In the Exercise.com platform, go to Clients and search for the client you updated.

24. Open the Nutrition Tab

From the client profile, click the Nutrition tab.

25. Verify Nutrition Goals

Confirm that the Nutrition Goals section shows the correct data from your Zap.

You’ve connected Google Sheets and Zapier with Exercise.com to automatically update client macros. This saves time and keeps client nutrition data accurate and up to date.