{"id":158668,"date":"2024-06-28T13:00:54","date_gmt":"2024-06-28T04:00:54","guid":{"rendered":"https:\/\/support.questetra.com\/?p=158668"},"modified":"2024-06-28T13:14:08","modified_gmt":"2024-06-28T04:14:08","slug":"service-task-google-sheets-cell-updateandget","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-google-sheets-cell-updateandget\/","title":{"rendered":"Google Sheets: Update & Get Cells"},"content":{"rendered":"\n
<\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

Google Sheets: Update & Get Cells<\/strong><\/h4>\n\n\n\n

Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u30bb\u30eb\u66f4\u65b0\uff06\u53d6\u5f97<\/a><\/p>\n\n\n\n

This item updates values of cells and gets updated values of other cells on Google Sheets.<\/p>\n\n\n\n

\n
Basic Configs<\/summary>
\n
\n
<\/dt>
Step Name<\/dd>\n
<\/dt>
Note<\/dd>\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
\"Auto<\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\n
conf_OAuth2<\/dt>
C1: OAuth2 Setting *<\/span><\/dd>\n
conf_SheetId<\/dt>
C2: Spreadsheet ID *<\/span><\/dd>\n
conf_SheetTitle<\/dt>
C3: Sheet Title *<\/span><\/dd>\n<\/div>\n
conf_ValueInputOption<\/dt>
C4: How values should be interpreted when updating cells<\/dd>\n
conf_CellToUpdate1<\/dt>
C5-1R: Cell 1 to update (e.g. “A1”)#{EL}<\/sup><\/span><\/dd>\n
conf_ValueToUpdate1<\/dt>
C5-1V: New value for Cell 1#{EL}<\/sup><\/span><\/dd>\n
conf_CellToUpdate2<\/dt>
C5-2R: Cell 2 to update (e.g. “A1”)#{EL}<\/sup><\/span><\/dd>\n
conf_ValueToUpdate2<\/dt>
C5-2V: New value for Cell 2#{EL}<\/sup><\/span><\/dd>\n
conf_CellToUpdate3<\/dt>
C5-3R: Cell 3 to update (e.g. “A1”)#{EL}<\/sup><\/span><\/dd>\n
conf_ValueToUpdate3<\/dt>
C5-3V: New value for Cell 3#{EL}<\/sup><\/span><\/dd>\n
conf_CellToUpdate4<\/dt>
C5-4R: Cell 4 to update (e.g. “A1”)#{EL}<\/sup><\/span><\/dd>\n
conf_ValueToUpdate4<\/dt>
C5-4V: New value for Cell 4#{EL}<\/sup><\/span><\/dd>\n<\/div>\n
conf_CellToGet1<\/dt>
C6-1R: Cell 1 to get (e.g. “A1”)#{EL}<\/sup><\/span><\/dd>\n
conf_ValueDef1<\/dt>
C6-1V: Data item to save value of Cell 1<\/dd>\n
conf_CellToGet2<\/dt>
C6-2R: Cell 2 to get (e.g. “A1”)#{EL}<\/sup><\/span><\/dd>\n
conf_ValueDef2<\/dt>
C6-2V: Data item to save value of Cell 2<\/dd>\n
conf_CellToGet3<\/dt>
C6-3R: Cell 3 to get (e.g. “A1”)#{EL}<\/sup><\/span><\/dd>\n
conf_ValueDef3<\/dt>
C6-3V: Data item to save value of Cell 3<\/dd>\n
conf_CellToGet4<\/dt>
C6-4R: Cell 4 to get (e.g. “A1”)#{EL}<\/sup><\/span><\/dd>\n
conf_ValueDef4<\/dt>
C6-4V: Data item to save value of Cell 4<\/dd>\n<\/div>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n

Notes<\/span><\/h3>\n\n\n\n