# Only move a portion of one Google Sheet to another Google Sheet **URL:** \ **Category:** Questions\ **Created:** [July 25, 2022, 12:17pm UTC](https://community.make.com/t/only-move-a-portion-of-one-google-sheet-to-another-google-sheet/3075 "2022-07-25T12:17:48Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Gregg](https://avatars.discourse-cdn.com/v4/letter/g/df705f/32.png) [@Gregg](https://community.make.com/u/Gregg)\ **Post date:** [July 25, 2022, 12:17pm UTC](https://community.make.com/t/only-move-a-portion-of-one-google-sheet-to-another-google-sheet/3075/1 "2022-07-25T12:17:48Z")
I have a Google Sheet with 1,000s of rows and I only want to move 50 rows per day to another Google Sheet. I’d like the new 50 rows to overwrite all the rows on the recipient sheet. I believe I set up a time trigger (24 hours.) Then, I get a bit hazy. Thanks in advance for any ideas on how to pull 50 from one sheet and overwrite the previous 50 in another sheet. ---
**Author:** ![R-SimplifiedWebhooks](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/r-simplifiedwebhooks/32/3914_2.png) [@R-SimplifiedWebhooks](https://community.make.com/u/R-SimplifiedWebhooks)\ **Post date:** [July 25, 2022, 12:41pm UTC](https://community.make.com/t/only-move-a-portion-of-one-google-sheet-to-another-google-sheet/3075/2 "2022-07-25T12:41:36Z")
Hi @Gregg, at which point is it getting tricky for you? You might start with “get range values”(in the sheet with 1000s of rows) use a filter to only take 50 rows and end with “update rows” (in the recipient sheet). Can you share more specifically which step is making problems? Then we can look into that 🙂 ---
**Author:** ![Gregg](https://avatars.discourse-cdn.com/v4/letter/g/df705f/32.png) [@Gregg](https://community.make.com/u/Gregg)\ **Post date:** [July 25, 2022, 12:54pm UTC](https://community.make.com/t/only-move-a-portion-of-one-google-sheet-to-another-google-sheet/3075/3 "2022-07-25T12:54:02Z")
Richard, Let me play around with your suggestion. I just learned how to wait 24 hours before moving the data but the Get Range Values is likely the trick I needed. Thank you and I’ll come back if it’s still not working. ---
**Author:** ![R-SimplifiedWebhooks](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/r-simplifiedwebhooks/32/3914_2.png) [@R-SimplifiedWebhooks](https://community.make.com/u/R-SimplifiedWebhooks)\ **Post date:** [July 25, 2022, 1:58pm UTC](https://community.make.com/t/only-move-a-portion-of-one-google-sheet-to-another-google-sheet/3075/4 "2022-07-25T13:58:18Z")
Alright! 🙂 I’d suggest you to try your workflow/logic with e.g. 2 rows and if it works, just switch to 50 rows! 🙂 This way you can save your operations. Best, Richy ---
**Author:** ![Yodogawa](https://avatars.discourse-cdn.com/v4/letter/y/67e7ee/32.png) [@Yodogawa](https://community.make.com/u/Yodogawa)\ **Post date:** [December 12, 2022, 8:09am UTC](https://community.make.com/t/only-move-a-portion-of-one-google-sheet-to-another-google-sheet/3075/5 "2022-12-12T08:09:44Z")
I got a similar issue and found this thread. I did the [quote=“Richard\_Johannes, post:2, topic:3075”] “get range values” [/quote] but I am not sure about the “update rows” since make only allows for updating a row. Am I missing something here? ---
**Author:** ![R-SimplifiedWebhooks](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/r-simplifiedwebhooks/32/3914_2.png) [@R-SimplifiedWebhooks](https://community.make.com/u/R-SimplifiedWebhooks)\ **Post date:** [December 14, 2022, 2:16pm UTC](https://community.make.com/t/only-move-a-portion-of-one-google-sheet-to-another-google-sheet/3075/6 "2022-12-14T14:16:14Z")
@Yodogawa I think you can update multiple rows by making an API Call using the “Make an API Call” Module but this is quite advanced. Updating multiple rows using the “Update Row” module will just lead to more operations and you update one row after the other and not all at once 🙂 ---
**Author:** ![Yodogawa](https://avatars.discourse-cdn.com/v4/letter/y/67e7ee/32.png) [@Yodogawa](https://community.make.com/u/Yodogawa)\ **Post date:** [December 20, 2022, 12:31am UTC](https://community.make.com/t/only-move-a-portion-of-one-google-sheet-to-another-google-sheet/3075/7 "2022-12-20T00:31:02Z")
Thank you for that suggestion, I will take a look at that. Could you give some example as well? ---
**Author:** ![Bjorn.drivn](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/bjorn.drivn/32/4503_2.png) [@Bjorn.drivn](https://community.make.com/u/Bjorn.drivn)\ **Post date:** [December 20, 2022, 10:31am UTC](https://community.make.com/t/only-move-a-portion-of-one-google-sheet-to-another-google-sheet/3075/8 "2022-12-20T10:31:37Z")
You can always hire a Make Expert to help you if you can’t get this done: > **[Professional Services](https://community.make.com/c/solution-exchange/professional-services/56)** > > Hire a professional to automate things for you or promote your services as an automation pro. ---
**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 7, 2023, 3:14pm UTC](https://community.make.com/t/only-move-a-portion-of-one-google-sheet-to-another-google-sheet/3075/9 "2023-09-07T15:14:04Z")