DATA EXPORT
WelcomeKnowledge BaseFAQStart Today
  • ✨Welcome to Data Export Documentation
  • 🏠Data Export Website
  • 💻Data Export App
  • 🛒Shopify Testimonials
  • 📌Getting Started
    • Pre-Made Reports
    • Reports
    • Scheduler
    • Settings
    • Data Synchronization
    • Data Export: Basic Functionality
  • 🧠Knowledge Base
    • Welcome to the Knowledge Base
    • Reports
      • Customized Reports
      • Filters
        • 'Contains' & 'Not contains'
        • 'is' & 'is not'
        • 'include' & 'exclude'
        • 'is BLANK' & 'is not BLANK'
        • 'Begins with' & 'Ends with'
        • '= Equals' & '!= Not equals'
        • '> Greater than' & '< Lesser than'
        • '>= Greater than or equal' & '<= Lesser than or equal'
      • Sort
      • Custom Columns
        • Calculated Columns
          • Add Order line item properties to your report
          • Add Metafields to your report
        • Static Column
      • Formatting Tools
      • Clone & Delete
    • Scheduler
      • ⌚Hourly Schedule
      • 🌞Daily Schedule
      • 🗒️Weekly Schedule
      • 📅Monthly Schedule
      • 🔽Output Options
        • Email
        • FTP
        • Google Drive
        • Google Sheets
  • ❓FAQ
    • Welcome to Data Export FAQ
    • Reports
    • Schedule
    • Sales & Billing
    • Data Sync
    • Service
  • 📋Changelog
Powered by GitBook
On this page

Was this helpful?

  1. Knowledge Base
  2. Scheduler
  3. Output Options

Google Sheets

You can authorize Data Export with your Google Drive account to schedule your reports to be directly delivered to Google Sheets.

PreviousGoogle DriveNextWelcome to Data Export FAQ

Last updated 1 year ago

Was this helpful?

Steps to Schedule Reports to Google Sheets

  1. Open the report that needs to be scheduled.

  2. Click the button.

  1. Select how often you want to run the report like Hourly, Daily, Weekly, or Monthly, and proceed to the next step. Click on Save and continue.

  2. Pick the date & time when the reports need to be delivered. Click on Save and continue.

  3. Click on the Google Sheets tab and then, click on Connect.

  1. Select your Google account and click on Allow to grant permission for Data Export.

Note: We are only permitted to view the folder structure of your Google Drive, in order to select the folder in which the Google Sheet would be delivered. We do not have visibility or access to the contents of your Google Drive.

  1. Select the Google Drive folder in which you wish to receive and store the report.

  2. Enter the file name and Sheet title.

  3. Choose to Append, Add Sheets or Overwrite your report data.

  • Append: adds the new data at the end of previous report data.

  • Add Sheets: adds new data in a separate sheet in the same file.

  • Overwrite: Overwrites the previous report data and replaces it with the new report data.

  1. Finally, click the 'Save and Continue' button to complete the schedule setup.

That's it!. You have scheduled your reports to Google Sheets like a Pro!

🧠
🔽
🌟
📋