Integrate with Amalgam

Amalgam (formerly Calculate) is a browser for business data, making teams more efficient by giving them full access to the data inside the tools they use.

With the Amalgam and Gusto integration, you can build flexible automations from inside Excel or Google Sheets. Gusto integrates with Amalgam to push payroll data directly to an Excel document or Google Sheet, where you can calculate adjustments and load journal entries with ease. For complex or high-volume calculations, Amalgam can create custom syncs that run daily, weekly, or monthly. 

Customers who join Gusto from Amalgam will receive Gusto payroll free for their first three months.

Connect to Gusto from Amalgam

Before you get started, make sure you’re registered for a Amalgam account. 

1. Sign in to your Amalgam home page.
2. Click Add New Integration.
3. Scroll and hover over “Payroll & HR.”
4. Click Gusto.
5. 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.
6. Enter your Gusto admin credentials and click Sign In.
7. Select the company you’d like to connect and click Authorize.

You’ll be taken back to your Amalgam home page. Follow the steps below to start running reports with Gusto payroll data. 

Sync payroll information

Once you’ve connected to 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

Follow the steps below or follow along with this video to add the Amalgam plugin to Google Sheets.

1. Open Google Sheets. 
2. In the toolbar, click Extensions.
3. Choose Add-ons.
4. Click Get add-ons.
5. Use the search bar to find and select Amalgam.
6. 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. 
7. Enter your Amalgam credentials and click Login.

Now you can start running reports—follow the steps below under "Run payroll data reports in Google Sheets or Excel."

Add the Amalgam plugin to Excel

Follow the steps below or follow along with this video to add the Amalgam plugin to Excel.

1. Open your Excel program. 
2. Click Insert.
3. Choose Get Add-ins. 
4. Use the search bar to find Amalgam and click Add.
5. Click Continue.
6. If prompted, enter your Amalgam credentials and click Login.

Now you can start running reports—follow the steps below under "Run payroll data reports in Google Sheets or Excel."

Run payroll data reports in Google Sheets or Excel

Once you've added the Amalgam plugin to Google Sheets or Excel, here's how to run payroll data reports.

1. Open your Google Sheets or Excel program.
2. Open the Amalgam plugin:
   • Excel: in your toolbar, click Amalgam. 
   • Google Sheets: in your toolbar, click Extensions and choose Amalgam. 
3. Click the Reports tab.
4. Select the company and click Connect.
5. Your report will generate in the sheet's workbook. Fill out any applicable information and click Download data to run the report.

Amalgam uses Gusto data in a read-only manner. You can use the reports you run to use to calculate adjustments and load journal entries.

Troubleshoot syncing issues

Google Sheets Plugin is not appearing in the Homepage menu

• First, 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 Sheet plugin.

Unable to connect the integration

• Make sure you’ve verified your email in Amalgam. Unverified accounts cannot access plugin automations. If you haven't received a verification email, or if you believe your account has been disabled due to login issues, contact Amalgam using the information below.

Still need help? 

Contact Amalgam directly at [email protected].