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":"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":"Spotify","module_name":"spotify"}]},{"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":"Spotify","module_name":"spotify"},{"name":"YouTube","module_name":"youtube"},{"name":"Google Calendar","module_name":"google_calendar"},{"name":"MESH","module_name":"mesh"},{"name":"Raindrop.io","module_name":"raindrop"},{"name":"Telegram","module_name":"telegram"},{"name":"Todoist","module_name":"todoist"}]}],"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,"related_content":[{"type":"story","id":"7l3wBx9kQ2UT0AiRrYWw4n","title":"What is Jotform? Everything you need to know","slug":"what-is-jotform","category":"Business","discoverable":"false","description":"Click to learn what is Jotform and how to use it!","hero_image":{"background_image_url_1x":"https://images.ctfassets.net/mrsnpomeucef/7M4qQGqitWyRvW81oudgfc/7ba369c154e4983905462d773692b4a7/What_is_Jotform.png?w=720&h=360","background_image_url_2x":"https://images.ctfassets.net/mrsnpomeucef/7M4qQGqitWyRvW81oudgfc/7ba369c154e4983905462d773692b4a7/What_is_Jotform.png?w=1440&h=720","background_image_url_3x":"https://images.ctfassets.net/mrsnpomeucef/7M4qQGqitWyRvW81oudgfc/7ba369c154e4983905462d773692b4a7/What_is_Jotform.png?w=2880&h=1440","foreground_image_url_1x":null,"foreground_image_url_2x":null,"foreground_image_url_3x":"https://images.ctfassets.net/mrsnpomeucef/7M4qQGqitWyRvW81oudgfc/7ba369c154e4983905462d773692b4a7/What_is_Jotform.png?w=2880&h=1440","background_color":"#000000"},"url":"https://ifttt.com/explore/what-is-jotform"},{"type":"consumer_solution","id":null,"title":"Smart Home","slug":"smart-home","category":null,"discoverable":null,"description":"IFTTT helps people save time by automating and customizing their Smart Home.","hero_image":{"solutionImage":"https://images.ctfassets.net/mrsnpomeucef/4cRdiYmlgxhV1QC7aC6blO/299c647f84c351c386cfaa03b7e68850/v2.png"},"url":"https://ifttt.com/solutions/smart-home"},{"type":"consumer_solution","id":null,"title":"Group Location","slug":"group-location","category":null,"discoverable":null,"description":"IFTTT helps people save time by automating and customizing their Smart Home.","hero_image":{"solutionImage":"https://images.ctfassets.net/mrsnpomeucef/27QUvXvL9AK7k1RlDyFzMp/7ecf5a434dd9fd49f5183a03dc7a793f/gl-default-header-1.png"},"url":"https://ifttt.com/solutions/group-location"}],"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":"YCuopj5dRL-CEjKw-QZ23A","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=0niyE1dyIj2KMLDD3Gq3jA","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

You may also like

What is Jotform? Everything you need to know

Smart Home

Group Location