Zapier - Google Drive

Integrate Google Drive with Transifex to send source files and receive translation files.

Nina avatar
Written by Nina
Updated over a week ago

Below, we’ll guide you through setting up Google Drive and Transifex Zaps. However, the beauty of Zapier is that it’s flexible. You can use the supported triggers and actions to create similar Zaps connected to other services (e.g., HipChat or Box) or create something totally new.


Sending new files from Google Drive to Transifex

Suppose you store spreadsheets and documents you wish to translate on Google Drive. In that case, you can use Zapier to automatically upload new and updated files to Transifex while automatically sending completed translations back to Google Drive.

Please note that the procedure described here needs to be repeated for each directory in Google Drive or each project in Transifex. A single zap can be used to push multiple source files within the same Google Drive directory to Transifex.

  1. Create a new Zap.

  2. Choose Google Drive so that the zap will be triggered whenever something happens there.

  3. From the events list, choose the second option, "New File In Folder," as seen below:

    trigger_event_push_new_file_to_tx_from_GD.png#asset:9505

    Click "Continue" to proceed.

  4. Connect your Google Drive Account

    GD_account_zapier.png#asset:9506

    Press "Continue" to proceed.

  5. Choose the Google Drive path containing the source files you want to upload to Transifex.

    GD_Path_zapier.png#asset:9507

    Press "Continue" to proceed and click 'Test the trigger' to ensure the criteria set are correct. After receiving the successful message, press "Continue" to move on to the next step.

  6. Now, we will configure the Transifex side. Choose the latest version of Transifex when prompted to do so, as seen below:

    transifex_zap_action_step.png#asset:9508

  7. From the events list, choose "Upload File":

    Upload_file_zapier.png#asset:9509

    Click "Continue" to proceed.

  8. Connect your Transifex User Account - Your API token will be requested, so you must visit your settings page and generate it as described here.

    tx_account_zapier_connection.png#asset:9510

    Click "Continue" to proceed.

  9. Select the organization you want to create a zap for and the project where the source content hosted in the specific Google Drive folder will be uploaded.

    Then, provide values for the rest of the fields as shown below:

    set_up_action_zapier.png#asset:9511

    Click on the "Continue" button to proceed, then "Test Action" to confirm everything is configured correctly. Once a successful message is received, you can save the Zap and turn it on.

  10. Troubleshooting:

    • Be patient. The zap can take up to an hour to trigger when uploading a new file to Google Drive.

    • If the file still hasn't been uploaded, please take a look at the following guide.


Updating Existing Resources in Transifex With Changes Detected in Google Drive

Please note that a zap needs to be created for each Google Drive directory or each Transifex project. However, a single zap can be used to push multiple updated files residing in the same Google Drive directory. As a prerequisite to this step, please create a Zap for "Sending new files from Google Drive to Transifex".

The same functionality can also be accomplished by the AutoUpdate Resource feature. The benefit of using Zapier is that your files do not need to be public. They can be private files that sit behind a secure login.

  1. From within your Zapier Home Page, copy the Zap created in step "Sending new files from Google Drive to Transifex". To do this, find your Zap, click the down arrow button, and select copy as seen below:

    copy-zap.jpg#asset:8055

  2. Once the Zap is copied, click the down arrow button again to rename it. Then click on the zap to edit it.

  3. Click on the Google Drive entry and modify the event from New File to Updated File as seen below:

    event_updated_file_zapier.png#asset:9512

    Click "Continue" twice to proceed.

  4. Customize the updated file parameters as seen below:

    zapier_updated_files_set_up.png#asset:9513

    Click "Continue" to proceed.

  5. Update a file on Google Drive and test to ensure the update is detected.

    Click "Continue" to proceed.

  6. Turn on the Zap if the test is successful.

  7. Troubleshooting:

    • Any source updates after turning on your zap may take up to 1 hour to trigger the zap.

    • When a file is deleted in Google Drive, that file has to be deleted in Transifex either manually, through the CLI Client, or the API.


Sending Completed Translations From Transifex to Google Drive

Please note that a single zap is required for each directory in Google Drive or each project in Transifex. However, a single zap will upload translation files from multiple resources and language pairs.

  1. Create a new Zap.

  2. Choose Transifex so that whenever something happens there, the zap will be triggered - Search for the latest version as seen below:

    zapier_step_1_push_complete_translations.png#asset:9514

  3. Select "Localization Activity Completed"

    localization_activity_completed_zapier.png#asset:9515

    Click "Continue" to proceed.

  4. Connect your TX User Account:

    connect_tx_account_zapier_push_translations.png#asset:9516

    Click "Continue" to proceed.

  5. Set up the trigger by selecting the organization you want to create this zap for and the project where the translations are hosted.

    Then, define when the translations in your Google Drive folder will be updated:

    events_for_complete_translations_zapier.png#asset:9517

    You can select more than one event from the list:

    multiple_events_zapier.png#asset:9518

    Click "Continue" to proceed.

  6. Click "Test trigger" to confirm that the zap was configured correctly. Once you receive a successful message, click "Continue" to proceed.

  7. Add a new action. Find the latest version of the Transifex App and select it.

    action_connect_transifex_zapier.png#asset:9519

  8. Select "Download file from Transifex" as the Action Event.

    download_file_action_event_zapier.png#asset:9520

    Press the "Continue" button to proceed.

  9. Choose the account created/used in step 4 above. Press "Continue" to proceed.

  10. In the "Set up action" section, populate the dropdowns as seen below:

    set_up_action_zapier_push_translations.png#asset:9521

    Press "Continue" to proceed.

  11. As an option, test the configuration to see if a file is downloaded. Keep in mind that this test will not return anything if you don't have any languages in your project that are 100% translated.

    Click "Test Action" to proceed.

  12. Add a new action for Google Drive. Find the "Google Drive" app and select it.

  13. Select Upload file as Action event:

    Upload_file_to_DG_Zapier.png#asset:9522


    Press "Continue" to proceed.

  14. Connect your Google Account and press "Continue" to proceed:

    action_3_connect_Google_account.png#asset:9526

  15. Customize the "Upload File" (i.e., translation file) as seen below and then press the "Continue" button to proceed:

    action_3_push_translations_to_GD_set_up_action.png#asset:9527

Note that the "Filename" is customizable with a mix of text and predefined variables.

Please always use the predefined variables if you wish to use this zap for all the resources in a given project. The "Filename of the file:" parameter uses the resource slug of the source file. If you are unhappy with the resource slug, you can change it in Transifex.

⚠️Warning: To prevent translation files from syncing with your Transifex project as source files, please choose a different folder in Google Drive to store your translations from where you keep your source files.

Click "Continue," then "Test Action" to confirm a successful setup, and once you are done, turn on your zap.


Additional Reading


💡Tip

Looking for more help? Get support from our Transifex Community Forum!

Find answers or post to get help from Transifex Support and our Community.

Did this answer your question?