Developer & DevOps

Automate Google Sheets

13 nodes 206 125 Scheduled trigger
Download

Workflow Description

An automation template that collects Strava activity data automatically into a Google Sheets spreadsheet, then removes duplicates and sorts the data, providing an organized and automatically updated view of your sports performance.

How it works

  1. 1.Enable the scheduled trigger to execute the automation at set intervals
  2. 2.Fetch activity data from your Strava account through the API connection
  3. 3.Process and clean the data by removing duplicates and sorting by specified criteria
  4. 4.Write the cleaned and organized data into the Google Sheets spreadsheet

Use cases

  • Track fitness statistics and physical activities automatically in an organized format without manual data entry
  • Generate updated performance reports that refresh automatically based on your latest Strava activities

Requirements

  • An active Strava account with valid API access credentials configured
  • A pre-created Google Sheets spreadsheet with write and edit permissions enabled

Service Value

Ready-made workflow template for automation delivery and service execution.

Apps Used

Strava Google Sheets Remove Duplicates Sort

Details

Trigger Scheduled trigger
Nodes 13
Apps 4
Views 206
Downloads 125

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (13)

/

Schedule Trigger

Schedule Trigger

#1

Strava

Strava

#2

Code

Code

#3

Google Sheets

Google Sheets

#4

strava_last

Set

#5

Remove Duplicates

Remove Duplicates

#6

activities

Google Sheets

#7

sort_saved

Sort

#8

last_saved

Limit

#9

saved_last

Set

#10

sort_strava

Sort

#11

last_strava

Limit

#12

sort_results

Sort

#13