# How to read multiple sheets in one spreadsheet using googlesheet : Read plugin?

**URL:** <https://community.automationedge.com/t/how-to-read-multiple-sheets-in-one-spreadsheet-using-googlesheet-read-plugin/6321>\
**Category:** AutomationEdge API\
**Created:** [October 17, 2022, 1:45pm UTC](https://community.automationedge.com/t/how-to-read-multiple-sheets-in-one-spreadsheet-using-googlesheet-read-plugin/6321 "2022-10-17T13:45:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Samiksha\_Gurav](https://avatars.discourse-cdn.com/v4/letter/s/3da27b/32.png) [@Samiksha\_Gurav](https://community.automationedge.com/u/Samiksha_Gurav)\
**Post date:** [October 17, 2022, 1:45pm UTC](https://community.automationedge.com/t/how-to-read-multiple-sheets-in-one-spreadsheet-using-googlesheet-read-plugin/6321/1 "2022-10-17T13:45:42Z")

</div>

suppose there is one spreadsheet named marksDetails.xlsx Nd sheets name 12A,12B,12C and we want to read all sheets.

---

<div class="post-metadata">

**Author:** ![KalyaniW](https://avatars.discourse-cdn.com/v4/letter/k/71e660/32.png) [@KalyaniW](https://community.automationedge.com/u/KalyaniW)\
**Post date:** [October 19, 2022, 7:43am UTC](https://community.automationedge.com/t/how-to-read-multiple-sheets-in-one-spreadsheet-using-googlesheet-read-plugin/6321/2 "2022-10-19T07:43:04Z")

</div>

Hello @Samiksha_Gurav

We can only read one single sheet from spreadsheet using GoogleSheet: Read plugin step.

If you want to read multiple sheets use multiple GoogleSheet: Read steps in a workflow.

Please find reference screenshot -

 ![GoogleSheet_Read](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/2X/7/7260c5bff0ac25e4a0eeb517028bf4b9936a74a9.png)

---

<div class="post-metadata">

**Author:** ![wllmdjngh](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.automationedge.com/wllmdjngh/32/952_2.png) [@wllmdjngh](https://community.automationedge.com/u/wllmdjngh)\
**Post date:** [October 19, 2022, 1:04pm UTC](https://community.automationedge.com/t/how-to-read-multiple-sheets-in-one-spreadsheet-using-googlesheet-read-plugin/6321/3 "2022-10-19T13:04:11Z")

</div>

In case all sheets have the same format/data, you may include all the sheets in the Excel Input and read them all at once in one step.  
additional field can be appended that reports from which sheet record was extracted.