Google Sheets Daily Backup to SharePoint

Overview

This flow gives a Google Sheet a governed, point-in-time backup inside Microsoft 365. On a nightly schedule it reads the configured worksheet, converts the rows to CSV, versions the file into a dated SharePoint folder, prunes backups older than a retention window, and posts a success or failure note to Microsoft Teams. Why it matters: Google Sheets edits are easy to lose or overwrite, and Google's own version history is hard to govern centrally. Scheduled, retained CSV snapshots in SharePoint give the team an auditable, recoverable backup that lives alongside the rest of their Microsoft 365 content. Status: Ships Off — going live requires only connection authorization and setting the environment-variable values (no logic changes).

Use Case

A team relies on a critical Google Sheet (a tracker, register, or roster) and wants automatic dated backups in SharePoint without manual exports. IT Admins and Operations get a hands-off retention policy and a daily confirmation in Teams that last night's snapshot was captured.

Flow Architecture

Environment Variables

Connectors & Connections

Connector	API name	Actions used
Google Sheets	shared_googlesheet	GetItems
SharePoint	shared_sharepointonline	CreateFile GetFileItems DeleteItem
Microsoft Teams	shared_teams	PostMessageToConversation

Note — All connections are referenced as solution connection references; the flow is portable between environments as long as a connection is mapped at import time.

Customization Guide

Almost every realistic variant of this flow can be implemented by changing environment variable values. A few cases require small edits inside the flow definition — those are called out explicitly below.

Schedule

Change the Nightly Backup recurrence (frequency/interval/start time) to back up more or less often.

Retention

Adjust flowlibs_RetentionDays; the prune step is fully driven by this value.

Multi-tab backup

Wrap the export steps in a Foreach over a list of worksheet names to back up every tab into the same dated folder.

Raw .xlsx instead of CSV

Replace GetItems + Create CSV table with the Google Sheets file-export op and write the binary with CreateFile.

Hash skip

Store a hash of the rows and skip the backup when the sheet is unchanged since the last run.

Folder cleanup

After pruning files, optionally delete now-empty dated folders.

Key Expressions

The flow is intentionally light on Power Fx / WDL gymnastics — the heaviest expressions are the branch-name concatenation and the approval outcome check. They are listed below in the order they appear in the flow.

@concat(variables('varLibraryPath'),'/',formatDateTime(utcNow(),'yyyy-MM-dd'))

@concat(variables('varBackupFilePrefix'),'_',formatDateTime(utcNow(),'yyyyMMddHHmmss'),'.csv')

@less(item()?['Modified'], addDays(utcNow(), mul(-1, variables('varRetentionDays'))))

@string(length(body('Get_Sheet_Rows')?['value']))

@string(length(body('Filter_Old_Backups')))

@int(parameters('EnvVar_RetentionDays'))

Customize & download