Error "Only The Following Activities Are Valid For Spreadsheet Update Batching: Write Cell, Write Range" For 'Batch Document Updates' Activity

News Knowledge Base
1

How to resolve the error "Only the following activities are valid for spreadsheet update batching: Write Cell, Write Range" for 'Batch Document Updates' activity?

Issue Description

The Batch Document Updates activity sends a single batch update that includes the values from each of the Google Docs activities nested inside this activity. This activity can be used when multiple changes are to be made to a single document.


The Batch Document Updates activity supports only the following activities:

  1. Write Cell
  2. Write Range


When activities other than the above two activities are added to the Batch sequence of the Batch Document Updates activity, the following error is encountered: Only the following activities are valid for spreadsheet update batching: Write Cell, Write Range


Resolution

Use only the following Google Workspace activities within the Batch sequence of the Batch Document Updates activity:

  1. Write Cell
  2. Write Range