• Home
    • About
    • Services
      • All Services
      • Google Spreadsheet Automation
      • Google Docs
      • Google Forms
      • Google Calendar
      • Gmail
      • Google Drive
      • MS Excel Automation with VBA
      • MS Excel Formulas & Template Designing
      • API & Third party Integration
      • Data Visualization
    • Products
      • Sutra Tools
      • Mail Merge Sutra
      • Reconciliation Sutra
    • Contact Us
  • Contact Info

    • Ahmedabad , India
    • ---
    • support@sutraanalytics.com
      • Home
      • About
      • Services
        • All Services
        • Google Spreadsheet Automation
        • Google Docs
        • Google Forms
        • Google Calendar
        • Gmail
        • Google Drive
        • MS Excel Automation with VBA
        • MS Excel Formulas & Template Designing
        • API & Third party Integration
        • Data Visualization
      • Products
        • Sutra Tools
        • Mail Merge Sutra
        • Reconciliation Sutra
      • Contact Us
    Sutra Analytics
    Sutra Analytics
    • Home
    • About
    • Services
      • All Services
      • Google Spreadsheet Automation
      • Google Docs
      • Google Forms
      • Google Calendar
      • Gmail
      • Google Drive
      • MS Excel Automation with VBA
      • MS Excel Formulas & Template Designing
      • API & Third party Integration
      • Data Visualization
    • Products
      • Sutra Tools
      • Mail Merge Sutra
      • Reconciliation Sutra
    • Contact Us

    Cart

    How to Get Files From Folder In Google Sheet

    Sutra Analytics > Blog > Sutra Tools > How to Get Files From Folder In Google Sheet
    • Sutra Tools

    If you want to list files from the drive folder with some file attributes like file name/file id/file URL/file size/file last updated/file editor/file owner or many more…

    This task could be more time-consuming if you happen to manually copy-paste the file names and other information.

    Sutra Tools will help you to get the files from any drive folder almost instantly with a few simple clicks.

    CLICK HERE to Install the addon.

    How to Open Functionality:

    • First of all open the Google sheet then go to Extension > Sutra Tools > Get Files From Folder like the below screenshot:
    • You will see the below dialog box.

    Use of Functionality:

    • First of all, You will need to either Enter the Folder URL or Select the Folder from the drive from which you want to list your files. After that Choose Sheet or enter the Sheet name in which you want to store files data.
    • You can select all the fields or the fields which you require from the available fields.
    • Hit Submit button and data will be stored in the sheet which you selected from the above step.

    Note: If you enter a sheet Name that already exists then all the data will be cleared from the existing sheet and new data will be entered.

     

    Tags: excelgoogle sheet

    Leave a Reply Cancel reply

    Your email address will not be published. Required fields are marked *

    Mail Merge Sutra Contents

    Getting Started Mail Merge Sutra
    FAQ & User Guide Mail Merge Sutra

      Contact Us

      • C-906 Ganesh Glory 11, Nr. BSNL Office, Jagatpur, Ahmedabad, Gujarat 382470
      • +91 79840 99467
      • support@sutraanalytics.com
      • 10:00 AM To 7:00 PM

      Navigation

      • Home
      • About Us
      • Services
      • Portfolio
      • Blog
      • Contact Us

      Copyright 2022 - 2023 - Sutra Analytics PVT LTD., All rights reserved.