Amalgam (formerly Calculate) is a browser that helps your team work more efficiently with business data. It gives you full access to this data from the tools you already use.
When you connect Amalgam with Gusto, you can run automatic tasks inside Excel or Google Sheets. Gusto sends your payroll data straight to your spreadsheets. From there, you can calculate adjustments and create journal entries without switching between programs. Need more complex or high-volume calculations? Amalgam can set up custom syncs that run daily, weekly, or monthly.
New Gusto customers who join through Amalgam get three months of free payroll.
Before you get started, make sure to register for an Amalgam account first.
Then, admins can connect to Gusto from Amalgam by following these steps:
Click Add New Integration.
Scroll and hover over Payroll & HR.
Click Gusto.
If you’re already a Gusto user, click Connect to Gusto.
If you're new to Gusto, click Create Gusto account and complete onboarding. Once your Gusto account is set up, return to Amalgam to finish connecting the integration.
Enter your Gusto admin credentials and click Sign In.
Select the company you’d like to connect and click Authorize.
You’ll be taken back to your Amalgam home page.
Once you’ve registered for an Amalgam account and connected Amalgam with Gusto, you can run reports with Amalgam's Google Sheets or Excel plugin. The reports include only payroll data. Employee or contractor profile information is not included.
Add the Amalgam plugin to Google Sheets
Admins can follow the steps below or follow along with this video to add the Amalgam plugin to Google Sheets.
Open Google Sheets.
In the toolbar, click Extensions.
Choose Add-ons.
Click Get add-ons.
Use the search bar to find and select Amalgam.
Click Install.
If you're a Google Workspace administrator, you may have the option to Install for my organization. This will grant your whole team access to the Amalgam plugin.
Enter your Amalgam credentials and click Login.
Now you can start running reports. Skip to the Run payroll data reports in Google Sheets or Excel section.
Add the Amalgam plugin to Excel
Admins can follow the steps below or follow along with this video to add the Amalgam plugin to Excel.
Open Excel.
Click Insert.
Choose Get Add-ins.
Use the search bar to find Amalgam and click Add.
Click Continue.
If prompted, enter your Amalgam credentials and click Login.
Now you can start running reports.
Once you've registered for an Amalgam account, connected Amalgam with Gusto, and added the Amalgam plugin to Google Sheets or Excel, you can run payroll data reports.
Admins can run payroll data reports by following these steps:
Open your Google Sheets or Excel program.
Open the Amalgam plugin. If you're using Excel, click Amalgam in the toolbar. If you're using Google Sheets, click Extensions in the toolbar and then choose Amalgam.
Click Reports.
Select the company and click Connect.
Your report will be created in the sheet's workbook. Fill out any needed information and click Download data to run the report.
Amalgam uses Gusto data in a read-only way. You can use these reports to calculate adjustments and load journal entries.
Google Sheets plugin does not appear in the Homepage menu
Make sure you’re signed in to the correct Google account, then reload the page. The Google account you’re using must match the Google account linked to the Google Sheets plugin.
Unable to connect the integration
Make sure you’ve verified your email in Amalgam. Unverified accounts cannot access plugin automations. If you have not received a verification email, or if you think your account was locked due to login issues, contact Amalgam using the information below.
Contact Amalgam directly at [email protected].