# I want to connect spreadsheet in a way that it routs certain rows in different spreadsheets

**URL:** https://community.make.com/t/i-want-to-connect-spreadsheet-in-a-way-that-it-routs-certain-rows-in-different-spreadsheets/43217
**Category:** Questions
**Tags:** functions, google-sheets
**Created:** [June 25, 2024, 7:30am UTC](https://community.make.com/t/i-want-to-connect-spreadsheet-in-a-way-that-it-routs-certain-rows-in-different-spreadsheets/43217 "2024-06-25T07:30:41Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Anubhav\_Agarwal](https://avatars.discourse-cdn.com/v4/letter/a/e274bd/32.png) [@Anubhav\_Agarwal](https://community.make.com/u/Anubhav_Agarwal)
#### Post date: [June 25, 2024, 7:30am UTC](https://community.make.com/t/i-want-to-connect-spreadsheet-in-a-way-that-it-routs-certain-rows-in-different-spreadsheets/43217/1 "2024-06-25T07:30:41Z")

</div>

## Connecting Spreadsheets to Route Rows Based on Conditions

Here’s how to format your request to get helpful responses on connecting spreadsheets to route rows based on conditions:

**Goal:**

- Explain what you want to achieve with the connected spreadsheets.
- Be specific about how the rows should be routed.
- Mention the criteria used to decide which spreadsheet a row belongs to (e.g., value in a specific column, existence of a certain keyword).

**Example:**

> I want to connect two spreadsheets. One spreadsheet contains customer data, and the other is for processing orders. I want to automatically route rows from the customer data spreadsheet to the order processing spreadsheet based on a “needs processing” flag in the customer data. Rows with a “Yes” in the flag column should be copied to the order processing spreadsheet.

---

<div class="post-metadata">

### Author: ![Anshul\_Soni](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/anshul_soni/32/41106_2.png) [@Anshul\_Soni](https://community.make.com/u/Anshul_Soni)
#### Post date: [June 25, 2024, 7:33am UTC](https://community.make.com/t/i-want-to-connect-spreadsheet-in-a-way-that-it-routs-certain-rows-in-different-spreadsheets/43217/2 "2024-06-25T07:33:20Z")

</div>

Hey @Anubhav_Agarwal ,  
can you briefly explain with screenshots, the info is incomplete

---

<div class="post-metadata">

### Author: ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)
#### Post date: [September 23, 2024, 7:36am UTC](https://community.make.com/t/i-want-to-connect-spreadsheet-in-a-way-that-it-routs-certain-rows-in-different-spreadsheets/43217/3 "2024-09-23T07:36:14Z")

</div>