# How to call multiple sheets with the same script? (Apps Script)

**URL:** https://community.glideapps.com/t/how-to-call-multiple-sheets-with-the-same-script-apps-script/44431
**Category:** Ask for Help
**Created:** [July 13, 2022, 8:30pm UTC](https://community.glideapps.com/t/how-to-call-multiple-sheets-with-the-same-script-apps-script/44431 "2022-07-13T20:30:38Z")
**Posts on this page:** 1
**Showing post:** 13

<div class="post-metadata">

### Author: ![Tim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim/32/13534_2.png) [@Tim](https://community.glideapps.com/u/Tim)
#### Post date: [July 14, 2022, 8:36am UTC](https://community.glideapps.com/t/how-to-call-multiple-sheets-with-the-same-script-apps-script/44431/13 "2022-07-14T08:36:57Z")

</div>

Hey Uzo

That was my basis:

> [@Scripts, scripts, scripts!](https://community.glideapps.com/t/scripts-scripts-scripts/18965/41):
>
> A Script to send SMS notifications via Twilio or Email via your gmail account in case phone number is not available function Twilio() { var ss = SpreadsheetApp.getActive().getSheetByName("Notifications"); var values = ss.getRange("A2:H").getValues(); for (var i in values) { var row=i; var r = +row + 2; if (values[i][5] != '' && values[i][7] == '' ) { var number = values[i][5] var message = values[i][6] function sendSms(to, body) { …

`var sheet = ss.getSheetByName(name);` refers to row 7 this calls the array above.

---

_[View the full topic](https://community.glideapps.com/t/how-to-call-multiple-sheets-with-the-same-script-apps-script/44431)._
