title: How can I create an unlimited range for cloud functions?
body: <p>I'm creating a cloud function to read a google spreadsheets and I want that use an unlimited range. It´s that possible?</p>
  <p>The idea is read the Google spreadsheets and send the data to firebase.</p>
  <p>I know that in Google spreadsheets I can use something like this &quot;Shets1!A2:L&quot;.</p>
  <p>My function it would be something like this:</p>
  <pre><code>exports.readsheets_Filmes = functions.https.onRequest(async (request, response) =&gt; {
      const jwtClient = new google.auth.JWT({
          email: serviceAccount.client_email,
          key: serviceAccount.private_key,
          scopes: ['https://www.googleapis.com/auth/spreadsheets']
      })
  
      await jwtClient.authorize() // Autorização para acesso
      
  
      const {data} = await sheets.spreadsheets.values.get({
          auth: jwtClient,
          spreadsheetId: &quot;&quot;,
          range: `Shets!A2:L`,
      })
  
      data.values?.forEach(row =&gt; {
          const [title, main_genre, genre_two] = row
          firestore.collection(&quot;Filmes&quot;).doc().set({
              title, main_genre, genre_two
          })
      })
  })
  </code></pre>
  <p>I created this functions using typescript.</p>
  <p>Does anyone know how to answer this problem?</p>