Integrate Microsoft Dynamics 365 Business Central with Google Sheets

Send information between Microsoft Dynamics 365 Business Central and Google Sheets automatically, without writing any code, using Zoho Flow.

Build your own integrations between Microsoft Dynamics 365 Business Central and Google Sheets

Connect Microsoft Dynamics 365 Business Central and Google Sheets with over 1000+ apps and build your own integrations using our no-code drag and drop builder and comprehensive workflow elements

Supported triggers and actions

Integrate Microsoft Dynamics 365 Business Central and Google Sheets using the below triggers and actions

All Triggers - A trigger kickstarts the flow

Record created or updated

Triggers when a record is created or updated in selected entity

Worksheet created

Triggers when a new worksheet is created in the selected spreadsheet

Row added

Triggers when a new row is added to the bottom of the selected worksheet

All Actions - Actions are the automated tasks

Create record

Creates a record in selected entity

Update record

Updates an existing record in selected entity

Fetch record

Fetches records from a selected entity

Create row

Creates a new row in the selected worksheet

Create spreadsheet

Creates a new spreadsheet

Update row

Updates the specified row in the selected worksheet

Fetch row

Fetches an existing row by the given value

What is Microsoft Dynamics 365 Business Central?

Microsoft Dynamics 365 Business Central is a cloud-based ERP solution for small and mid-sized businesses. It brings together finance, supply chain, sales, service, and operations in one platform to help you manage and automate your business processes.

What is Google Sheets?

Google Sheets lets you create and edit spreadsheets online. You can collaborate with others, define formulas, and create graphs and charts easily.

Google Popular Spreadsheet

Build comprehensive workflows using

Webhook triggers

Receive your data from a wider range of services in multiple formats, like JSON, form data, and plain text.

Learn more >

Logic

Create customized business workflows by including advanced logic elements like if-then branches, time delays, and more.

Learn more >

Custom functions

Write simple scripting functions to format data, call web APIs, send emails, and more.

Learn more >

Zoho Flow is an easy-to-use, very intuitive, and comprehensive integration platform. It helped us integrate Zoho Workplace with WordPress without writing a single line of code. Now, we do not miss Slack anymore, thanks to Zoho Flow and Zoho Workplace.

Rahul Roushan

CEO, Alebat Education

Zoho Flow has made our merchant onboarding at least 15 times faster—from 15 days down to under 24 hours. It also keeps our data in sync across our business apps in real time, so we're making decisions on current and accurate information.

Hugo Garcia

CEO, Roofing solutions company (Moriarty's Roofing)

Using Zoho Flow, we’re able to tie together different Zoho applications into a cohesive and sophisticated system. It has also enabled SHARC to avoid messy external solutions, like Zapier, that can be a struggle to maintain and create more costs. Zoho Flow directly saved over 400 hours/year of the staff’s time from having to input or interact with the system unnecessarily, and improved accuracy by reducing human error.

Brett Stewart

Senior Project Manager, Syncify

Watch Zoho Flow in action

Play video

Endless integrations. End to manual work.

SIGN UP TODAY