Google Sheets + Lokalise
Create spreadsheet rows in Google Sheets when language tasks are closed in Lokalise
Effortlessly manage your localization projects with this workflow. Whenever a language task is finished in Lokalise, a new row is created in your Google Sheets, helping you keep organized and updated track of task completions. It saves you time and ensures accuracy across multiple languages, providing a valuable and efficient solution to language project coordination.
Effortlessly manage your localization projects with this workflow. Whenever a language task is finished in Lokalise, a new row is created in your Google Sheets, helping you keep organized and updated track of task completions. It saves you time and ensures accuracy across multiple languages, providing a valuable and efficient solution to language project coordination.
- When this happens...
Task Language ClosedTriggers when a language is closed in the task.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Team IDRequired
Project IDRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Project IDRequired
Task type
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Project IDRequired
Key IDRequired
Comment
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Team IDRequired
Project NameRequired
Description
Base language code
Project type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
File format
Use original filenames
Bundle structure
Directory prefix
All platforms
Filter by languages
Filter data
Filter by filenames
Add Newline at EOF
Filter by custom translation status IDs
Include tags
Exclude tags
Sort by
Export empty as
Include comments
Include description
Include other projects
Triggers for integrations
Filter by repository
Replace breaks
Disable references
Plural format
Placeholder format
indentation
Filter Task ID
Yaml Include Root
JSON Unescaped Slashes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
Key IDRequired
Key Name
Description
Filenames
Tags
Merge Tags
Context
Character limit
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
DataRequired
Language codeRequired
FilenameRequired
Convert placeholders
Detect ICU plurals
Tags
Tag inserted keys
Tag updated keys
Tag skipped keys
Replace modified translations
Convert \n to line break
Copy keys to values
Distinguish keys by filename
Apply 100% TM matches
Use Automations
Hidden from contributors
Cleanup mode
Custom translation status IDs
CTS for inserted keys
CTS for updated keys
CTS for skipped keys
Skip language detection
Filter Task ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
Key IDRequired
Comment IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appTeam IDRequired
Order IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProject IDRequired
Task IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProject IDRequired
Disable References
Filter by Language ID
Filter by reviewed status
Filter by unverified status
Filter for untranslated keys.
Filter by QA Issues
Filter by Task ID
Pagination
Limit
Page
Cursor
ActionThis is an event a Zap performs.SearchFind existing data in your appProject IDRequired
Filter Title
Filter Statuses
Limit
Page
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Team IDRequired
Project IDRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Project IDRequired
Team IDRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Project ID
Key NameRequired
Key Description
PlatformsRequired
Filenames
Tags
Source language translation
Source Language ISO
Source Translation is Reviewed
Source Language is Unverified
Source Language Custom Translation Status
Comment
Plural
context
Character Limit
Use Automations
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
TitleRequired
Description
Due Date
Keys
Source Lang ISO
Languages
Auto Close Languages
Auto Close Task
Auto Close Items
Task Type
Parent Task ID
Closing Tags
Lock Translations
Custom Translation Status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
Translation IDRequired
Disable References
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
Translation IDRequired
TranslationRequired
Is Unverified
Is Reviewed
Custom Translation Status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
Key IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProject IDRequired
Simple Key Array
Disable References
Include Comments
Include Screenshots
Include Translations
Filter by Translation Language IDs
Filter Tags
Filter Filenames
Filter Key Names
Filter by Key IDs
Filter Platforms
Filter Untranslated
Filter QA Issues
Filter Archived
Pagination
Limit
Page
Cursor
ActionThis is an event a Zap performs.SearchFind existing data in your appProject IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appTeam IDRequired
Limit
Page
ActionThis is an event a Zap performs.SearchFind existing data in your appProject IDRequired
Key IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProject IDRequired
Key IDRequired
Disable References
ActionThis is an event a Zap performs.SearchFind existing data in your appNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Google Sheets
Related categories
