Seed a Range Only If Empty
A 2-step recipe with Google Sheets. We can help you get access.
Recipe · 2 steps
Seed a Range Only If Empty
with Google Sheets
Write seed values into a range only when that range is currently empty.
- Read the target range and branch on whether it already contains any values.
- Write the supplied seed values into the empty range using USER_ENTERED interpretation.
What you'll need to have ready
- accessToken: OAuth 2.0 bearer access token with the spreadsheets scope.
- spreadsheetId: The ID of the spreadsheet to seed.
- range: The A1 notation range to check and conditionally seed.
- values: A two-dimensional array of seed cell values to write when the range is empty.
For your developer
Arazzo workflow google-sheets:seed-if-empty, 2 operations: getValues → updateValues. Specs on APIs.io.