E-mail

"},{"id":"1781641913","name":"SpreadsheetData","normalized_name":"Jotform.latestFormSubmission.SpreadsheetData","label":"","note":"The form data in a CSV format.","slug":"spreadsheet_data","value_type":"string","example":"[]"},{"id":"1739409662","name":"FilteredRichTextData","normalized_name":"Jotform.latestFormSubmission.FilteredRichTextData","label":"","note":"The filtered form data in a tabulated HTML format.","slug":"filtered_rich_text_data","value_type":"string","example":"johndoe@mail.com

E-mail

"},{"id":"218587212","name":"FilteredSpreadsheetData","normalized_name":"Jotform.latestFormSubmission.FilteredSpreadsheetData","label":"","note":"The filtered form data in a CSV format.","slug":"filtered_spreadsheet_data","value_type":"string","example":"[]"},{"id":"1938282615","name":"FileUrl","normalized_name":"Jotform.latestFormSubmission.FileUrl","label":"","note":"The URL of the file(s) uploaded on your form.","slug":"file_url","value_type":"string","example":"http://www.jotform.com/uploads/user/1234567890/9876543210/images.zip"}],"trigger_fields":[{"name":"form_id","label":"Form","required":true,"shareable":false,"hideable":false,"field_ui_type":"collection_select","normalized_field_type":"option","helper_text":"Choose a form"},{"name":"question_filter","label":"Question Filter","required":true,"shareable":false,"hideable":true,"field_ui_type":"text_field","normalized_field_type":"text","helper_text":"Optional question filter (label text) e.g. Name, Email, Address"}]}},"applet_queries":[],"applet_actions":[{"action":{"full_module_name":"google_sheets.append_to_google_spreadsheet","id":"1050018592","module_name":"append_to_google_spreadsheet","name":"Add row to spreadsheet","normalized_module_name":"appendToGoogleSpreadsheet","description":"This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.","weight":3,"channel":{"allow_multiple_live_channels":true,"brand_color":"23448b","id":"799977804","lrg_monochrome_image_url":"https://assets.ifttt.com/images/channels/799977804/icons/monochrome_large.png","lrg_variant_image_url":"https://assets.ifttt.com/images/channels/799977804/icons/on_color_large.png","module_name":"google_sheets","monochrome_image_url":"https://assets.ifttt.com/images/channels/799977804/icons/monochrome_regular.png","name":"Google Sheets","published":true,"live_channels":[]},"action_fields":[{"normalized_module_name":"Filename","name":"filename","label":"Spreadsheet name","required":true,"shareable":true,"hideable":true,"field_ui_type":"text_field","normalized_field_type":"text","helper_text":"Will create a new spreadsheet if one with this title doesn’t exist"},{"normalized_module_name":"FormattedRow","name":"formatted_row","label":"Formatted row","required":true,"shareable":true,"hideable":true,"field_ui_type":"text_area","normalized_field_type":"text","helper_text":"Use “|||” to separate cells"},{"normalized_module_name":"Path","name":"path","label":"Drive folder path","required":false,"shareable":true,"hideable":true,"field_ui_type":"text_field","normalized_field_type":"text","helper_text":"Format: some/folder/path (defaults to “IFTTT”) "}]}}]},"code":"","connection":{"actions_delay":0,"applet_type":"desktop","applet_feedback_count":null,"archived":false,"author":"Jotform","author_id":null,"author_image_url":null,"author_tier":null,"background_images":{"background_image_url_1x":null,"background_image_url_2x":null,"background_image_url_3x":null,"sm_background_image_url":null,"lg_background_image_url":null},"brand_color":"#0a1551","by_service_owner":true,"can_push_enable":true,"channels":[{"name":"Jotform","module_name":"jotform","short_name":"Jotform","connected":false,"is_paused":false,"can_be_autoactivated":false,"brand_color":"0A1551","lrg_variant_image_url":"https://assets.ifttt.com/images/channels/609787381/icons/on_color_large.png","lrg_monochrome_image_url":"https://assets.ifttt.com/images/channels/609787381/icons/monochrome_large.png","monochrome_image_url":"https://assets.ifttt.com/images/channels/609787381/icons/monochrome_regular.png","live_channel":null,"id":"609787381","image_url":"https://assets.ifttt.com/images/channels/609787381/icons/monochrome_regular.png","available_to_everyone":true,"allow_multiple_live_channels":true,"published":true,"live_channels":[],"works_well_with_channels":[{"name":"Google Sheets","module_name":"google_sheets"},{"name":"LINE","module_name":"line"},{"name":"Telegram","module_name":"telegram"},{"name":"Gmail","module_name":"gmail"},{"name":"Blogger","module_name":"blogger"},{"name":"OneDrive","module_name":"onedrive"},{"name":"Dropbox","module_name":"dropbox"},{"name":"Google Docs","module_name":"google_docs"},{"name":"Asana","module_name":"asana"},{"name":"Google Drive","module_name":"google_drive"},{"name":"YoLink","module_name":"yolink"},{"name":"Facebook Pages","module_name":"facebook_pages"}]},{"name":"Google Sheets","module_name":"google_sheets","short_name":"Google","connected":false,"is_paused":false,"can_be_autoactivated":false,"brand_color":"23448b","lrg_variant_image_url":"https://assets.ifttt.com/images/channels/799977804/icons/on_color_large.png","lrg_monochrome_image_url":"https://assets.ifttt.com/images/channels/799977804/icons/monochrome_large.png","monochrome_image_url":"https://assets.ifttt.com/images/channels/799977804/icons/monochrome_regular.png","live_channel":null,"id":"799977804","image_url":"https://assets.ifttt.com/images/channels/799977804/icons/monochrome_regular.png","available_to_everyone":true,"allow_multiple_live_channels":true,"published":true,"live_channels":[],"works_well_with_channels":[{"name":"Location","module_name":"location"},{"name":"LINE","module_name":"line"},{"name":"Twitter","module_name":"twitter"},{"name":"Husqvarna Automower®","module_name":"automower"},{"name":"Rust","module_name":"rust"},{"name":"Google Calendar","module_name":"google_calendar"},{"name":"Spotify","module_name":"spotify"},{"name":"Telegram","module_name":"telegram"},{"name":"YouTube","module_name":"youtube"},{"name":"Raindrop.io","module_name":"raindrop"},{"name":"Todoist","module_name":"todoist"},{"name":"MESH","module_name":"mesh"}]}],"config_type":"static","description":"If your team uses Google Drive, this Applet will keep your form submissions easily accessible.","friendly_id":"rsNxeF3m-automatically-backup-your-jotform-entries-to-google-drive","icon_url":"https://assets.ifttt.com/images/channels/609787381/icons/on_color_large.png","id":"rsNxeF3m","installs_count":16,"intermediate_pro_features":false,"is_hidden":false,"just_enabled":false,"monochrome_icon_url":"https://assets.ifttt.com/images/channels/609787381/icons/monochrome_large.png","name":"Automatically backup your JotForm entries to Google Drive","permissions":[{"id":"/triggers/jotform.latest_form_submission","name":"New submission","description":"This Trigger fires on a new form submission.","service_slug":"jotform","service_name":"Jotform","icon_url":"https://assets.ifttt.com/images/channels/609787381/icons/monochrome_regular.png","brand_color":"#0a1551","available_to_everyone":true,"type":"trigger","live_channel":null,"service_id":"jotform"},{"id":"/actions/google_sheets.append_to_google_spreadsheet/0","name":"Add row to spreadsheet","description":"This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.","service_slug":"google_sheets","service_name":"Google Sheets","icon_url":"https://assets.ifttt.com/images/channels/799977804/icons/monochrome_regular.png","brand_color":"#23448b","available_to_everyone":true,"type":"action","live_channel":null,"service_id":"google_sheets"}],"pro_features":false,"published":true,"push_enabled":null,"requires_android_app":false,"requires_ios_app":false,"requires_mobile_app":false,"service_names":["Jotform","Google Sheets"],"service_slug":"jotform","services":["jotform","google_sheets"],"speed":"Polling Applets usually run within 1 hour","status":null,"uniq_permissions":[{"id":"/actions/google_sheets.append_to_google_spreadsheet/0","name":"Add row to spreadsheet","description":"This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.","service_slug":"google_sheets","service_name":"Google Sheets","icon_url":"https://assets.ifttt.com/images/channels/799977804/icons/monochrome_regular.png","brand_color":"#23448b","available_to_everyone":true,"type":"action","live_channel":null,"service_id":"google_sheets"}],"applet_feedback_by_user":null,"created_at":null,"last_run":null,"run_count":null,"type":"applet","value_propositions":[],"configurations":[]},"error":{"type":"","message":""},"mainService":{"name":"Jotform","module_name":"jotform","short_name":"Jotform","connected":false,"is_paused":false,"published":true,"can_be_autoactivated":false,"brand_color":"0A1551","lrg_variant_image_url":"https://assets.ifttt.com/images/channels/609787381/icons/on_color_large.png","lrg_monochrome_image_url":"https://assets.ifttt.com/images/channels/609787381/icons/monochrome_large.png","monochrome_image_url":"https://assets.ifttt.com/images/channels/609787381/icons/monochrome_regular.png","embedded_redirect_uris":[],"live_channel":null},"needsConfig":false,"dynamicConfig":false,"proPlusProductId":"prod_K75tUFZGARgxH4","services":[{"name":"Jotform","module_name":"jotform","short_name":"Jotform","connected":false,"is_paused":false,"published":true,"can_be_autoactivated":false,"brand_color":"0A1551","lrg_variant_image_url":"https://assets.ifttt.com/images/channels/609787381/icons/on_color_large.png","lrg_monochrome_image_url":"https://assets.ifttt.com/images/channels/609787381/icons/monochrome_large.png","monochrome_image_url":"https://assets.ifttt.com/images/channels/609787381/icons/monochrome_regular.png","embedded_redirect_uris":[],"live_channel":null},{"name":"Jotform","module_name":"jotform","short_name":"Jotform","connected":false,"is_paused":false,"published":true,"can_be_autoactivated":false,"brand_color":"0A1551","lrg_variant_image_url":"https://assets.ifttt.com/images/channels/609787381/icons/on_color_large.png","lrg_monochrome_image_url":"https://assets.ifttt.com/images/channels/609787381/icons/monochrome_large.png","monochrome_image_url":"https://assets.ifttt.com/images/channels/609787381/icons/monochrome_regular.png","live_channel":null},{"name":"Google Sheets","module_name":"google_sheets","short_name":"Google","connected":false,"is_paused":false,"published":true,"can_be_autoactivated":false,"brand_color":"23448b","lrg_variant_image_url":"https://assets.ifttt.com/images/channels/799977804/icons/on_color_large.png","lrg_monochrome_image_url":"https://assets.ifttt.com/images/channels/799977804/icons/monochrome_large.png","monochrome_image_url":"https://assets.ifttt.com/images/channels/799977804/icons/monochrome_regular.png","live_channel":null}],"sessionId":"yCal14pvTpL62_tNs45z3w","showAppletFailedToggle":"true","showFeedbackForm":false,"showMobileAlert":false,"showPublishCta":false,"signedIn":false,"user":{"tier":"free","eligible_for_trial":true,"_cancellation_requested_during_trialing":null},"userDevice":"desktop","urls":{"createPath":"/connections.json","activityPath":"/activity/applet/rsNxeF3m","savePath":"/connections/rsNxeF3m.json","disablePath":"/applets/rsNxeF3m/disable.json","editPath":"/applets/rsNxeF3m/edit","activationPath":"https://ifttt.com/bulk_channel_activation/new","myAppletURL":"https://ifttt.com/my_applets","returnTo":"https://ifttt.com/applets/rsNxeF3m-automatically-backup-your-jotform-entries-to-google-drive?%F0%9F%A7%82=Hda6p5vBuhwibprnuEN-WA","resetLoginPath":"/login","appStorePath":"https://ift.tt/app-store-download","googlePlayStorePath":"https://ift.tt/google-play-download","publishedAppletEditPath":null,"newProSubscriptionUrl":"https://ifttt.com/subscriptions/pro","newProPlusSubscriptionUrl":"https://ifttt.com/subscriptions/pro_plus","modalSubscriptionUrl":"https://ifttt.com/subscriptions/modal"},"webhookUrl":null}

Automatically backup your JotForm entries to Google Drive

If

New submission

Then

Add row to spreadsheet