Fetch Google Spreadsheet Row Mapping
Generates mapping from a spreadsheet row.
Generates mapping from a spreadsheet to be used with a table mapping node like Map Table Rows To Any node to convert it into useful data to be used inside the automation. See an screenshare example at the bottom of the page.
Input Fields
field | schema | explanation | example |
spreadsheet_id | google_drive_file_id | Select a spreadsheet from the dropdown. | - |
range | table_range | Enter a range for one | Sheet1 or Sheet1!A1:Z |
Output Fields
field | schema | explanation | example |
mapping | table_row_mapping | see below |
Example Usage
Example Dynamic Table Mapping Recipe
{"name":"Example Dynamic Table Mapping","description":"","nodes":{"start_1":{"type":"start","logging_enabled":false,"x":31,"y":319},"google_sheets_fetch_table_rows_v3_1":{"type":"google_sheets_fetch_table_rows_v3","logging_enabled":false,"x":232,"y":267,"inputs":{"spreadsheet_id":{"export_enabled":true,"data":{"id":"18B4s4rLsn4JCLnfrDCeKhxglx5icSZNOLhFhPj62Z8c","context":{"mime_type":"application/vnd.google-apps.spreadsheet","ui":{"id":"18B4s4rLsn4JCLnfrDCeKhxglx5icSZNOLhFhPj62Z8c","name":"Example - Automated Table Mapping","owners":[{"displayName":"Simon Kreienbaum","kind":"drive#user","me":true,"permissionId":"01137890803721275589","emailAddress":"simon@kitchn.io","photoLink":"https://lh3.googleusercontent.com/a-/ACB-R5TO3BdFJtiY3T4oSSOhf5M_YD3axFIif_9VxhYPOjcBL-WjOu-te-ck6n4uWy1tBd4n4O5_OQRbg_Ge5WmHcjLftLE3jtg8scyaxOuIBWDfkFm1zn3Z1b945dljP9sU7_1gKO7lKL9KblaLUdHP4nrpZoj66l7bW97PulVZMM57pXnz5LKJVs2BVrXo01TpmD-ZhjGKtMANO-rddbEwo4af1E959fjNsGVM_4OlbtrN1GgBCgGPUSv6Tj6C9TdO5R6NMBP0gqujh6UloZb6V-2gOdpwEUpoqFyeGaMicVqRy5cldscF3KTj7z4wacsqzUKwm201r-dcQ2WPd_AX9DqIjwHzVBKxn202XH4cwkQLU-zBpwyeGLVCfAUHrjaaEG9g1rzqq1YhX0TITKntLgZcIY5HA9xFA3Sltwt0eQIOCZm9A6QSvQLJrUJh-FiMQyD5RsD1RP5CwQN10gk9KPwG9khnenms70I5PgJPQlGUOGysTa8UKd27zX3bduLJOiWRrQtYJVL2nAdbjzCa9mHq4X1y9GNkPfk7fp-fdIqbZLPm4k1_l8Ooon96WY1HbSrksuNGAUJngfUMfg0831RPQmL75-RhPq4nIj-X5D7keD3-lxp4BFP8vPGr7pGDzXwapKRtcW-EQ5zUtUVBhRrObRlCsD2Dlbh1r1n9GO7g4DKXLSUEJ891PnKpUlqCzzPu9w1Nd0pYOIUT37QEKLbs3kpXdoxuEo_Q_4iUlo0M08juoqbelXDKdHp6_L71GLM4jxPg9PFHwHP1c7kZ1MkrkyHLMsPEkmvehcebU1DpisMR6xcN5CXOM8IHQKJqk3P7vogYhiqHiMn72TV_nAk1AtFOXc2i3YOwSkf2OILg-ZMrnwxrE-uIbtktWkSZlTC9zysWXq9mcqKaJ7c4BcsDK_MKDSYJfMiGcOqXLGWzlF1O9U6bvjSKTOg2=s64"}],"mime_type":"application/vnd.google-apps.spreadsheet"}},"provider":"google_drive","type":"file"}},"date_time_render_option":{"export_enabled":true,"data":"FORMATTED_STRING"},"value_render_option":{"export_enabled":true,"data":"UNFORMATTED_VALUE"},"dimension":{"export_enabled":true,"data":"ROWS"},"range":{"export_enabled":true,"data":"Sheet1!A4:Z"}}},"google_sheets_fetch_table_row_mapping_1":{"type":"google_sheets_fetch_table_row_mapping","logging_enabled":false,"x":542,"y":234,"inputs":{"range":{"export_enabled":true,"data":"Sheet1"},"spreadsheet_id":{"export_enabled":true,"data":{"id":"18B4s4rLsn4JCLnfrDCeKhxglx5icSZNOLhFhPj62Z8c","context":{"mime_type":"application/vnd.google-apps.spreadsheet","ui":{"id":"18B4s4rLsn4JCLnfrDCeKhxglx5icSZNOLhFhPj62Z8c","name":"Copy of Automated Table Mapping","owners":[{"displayName":"Simon Kreienbaum","kind":"drive#user","me":true,"permissionId":"01137890803721275589","emailAddress":"simon@kitchn.io","photoLink":"https://lh3.googleusercontent.com/a-/ACB-R5RyCXXdQR-uAF-Wh-FyIOL7v-ngdGhefbEk-R8t9cBPmrVR7tYD03dY2ZrnovKDd_nGahF9dYpyDwvqg0yDZRu1rma9dG4bQbgMjDGuLrjiMipzXuo7brkxepKorhqXKFfYhfT9jv-00SO50NyyeGkaTPxuXBka0SdHBavo5wOriTwX8EwkKaDOdd_BJCjae9eFtDVPgczAf2-kRiGBO4590PbJGQGuEFHiqQJUj9zWBJv9Aw33ZL0qO2k8mrhJe87Yk1VuQRK0Y_cpYSgnWchUFbZmxZt8ACOJUVOdhl-lWjNVPPbMdOD1KlH69n_lTPZMbZWxuNcMgv2IU-yjm0naBBW8sls9skdONf19kCGWGuP8zOZGjWhJYLRh6yk6nbpunHITVAhcOMVx6MXZkOPM5MnGsIjSGV8ByL4I4j2Xzs4SwTAnfVKC6d7XTpqnJg5M1qhjZq_aWVuFlzsOlsjvzQja5eyw6C-3Xj-eynLjeIBA4FnAthshv7N5PnWui2s4pNRKe8wd2keSoFG7xoUdWkUW5I2FtcndGpa0_Sp53awUgp64D6dVW7jvAHM3lHo-Ak-YpO51VgtJfBDKcid-XVq-UzG2cY38elIjwkK8AuE_H9r9WnifnLD1k3QLWBsGxcbkEaaOfoInZJqbc6UU5CxriE2_xecp7wMaPE2hcQ--7u4oISlRpbxOX9kUP0h0nYsBVSyjERs4hrdEMchzYGoTB19T_3PVG6TbmQamV9aZDG2tljux0pF-O92KLRQFC0ae97yncDkX0Ndipw-OmD6McMWaTtKubxS29lcQFzK8tQIzFYFf44peb4SCFKBRNvo3twCK2i7n8xf6ooh6xfUGppsNyTEw3ChD2VHgtrzlt65ZivbJ0JuUkOqiShGoUrkQbKcrCOu4iPXhdazX7if_C7mjhlbZ8U2mwYoJwLa3r2r67RH_Y9c8=s64"}],"mime_type":"application/vnd.google-apps.spreadsheet"}},"provider":"google_drive","type":"file"}}}},"map_table_rows_1":{"type":"map_table_rows","logging_enabled":false,"x":873,"y":367,"inputs":{"schema":{"export_enabled":true,"data":"any"}}},"patch_json_list_v2_1":{"type":"patch_json_list_v2","logging_enabled":false,"x":1189,"y":401,"inputs":{"patches":{"export_enabled":true,"data":[{"op":"remove","path":"/id/context"},{"op":"replace","path":"/data","value":{}},{"op":"add","path":"/data/checked","value":true}]},"value":{"export_enabled":true}}},"unmap_table_rows_1":{"type":"unmap_table_rows","logging_enabled":false,"x":1513,"y":393,"inputs":{"schema":{"export_enabled":true,"data":"any"}}},"google_sheets_update_table_rows_v2_1":{"type":"google_sheets_update_table_rows_v2","logging_enabled":false,"x":1826,"y":440,"inputs":{"spreadsheet_id":{"export_enabled":true,"data":{"id":"18B4s4rLsn4JCLnfrDCeKhxglx5icSZNOLhFhPj62Z8c","context":{"mime_type":"application/vnd.google-apps.spreadsheet","ui":{"id":"18B4s4rLsn4JCLnfrDCeKhxglx5icSZNOLhFhPj62Z8c","name":"Example - Automated Table Mapping","owners":[{"displayName":"Simon Kreienbaum","kind":"drive#user","me":true,"permissionId":"01137890803721275589","emailAddress":"simon@kitchn.io","photoLink":"https://lh3.googleusercontent.com/a-/ACB-R5RolxMTie_aQg3nXNW4ugTNvrX0CtFP8kVdBcHX61eW7QJztczgBfCIS4283SbfIpbfAFxvLiac6gxV4qRLFGhUqjQ-Cp3PK9_nAQQI0D0Wpf8veAWjN62aqIH4sf9w9hWrb6kqb7HL6CK59mzX3GvE6XNZVjon72c3-8KwElh8DT8ivY7dp-NJlsAt4-B-FejjCsSGy47vX4CnzjuMh7xAI7Od5ppg9C_WU0axNZEe9fKYJ_q0KgxBlPczVfGQc2MECTExVMkQGPCxBCMBytzBLhOihriYcEew1N_x8O3L_VN-EgwruDrlKeUeGf3M2pbBLLPOgHDwDAqDjKF5k3l32ygj0mOMrw6UDoasYy4xMkh9_K_BEQPxY3ja6YzGu5AaKDs70GIscCAWhTqtawCAHKp9SpggIAJQo4-BmPQdC0X7-GDcd0mKZuDbnourqZU-tK9E4gXBw40vwskSQMkU6rTC0zUdmzJDTVpykj3N3l9iuSoANwbaeZP99hEuQd1Pv6tRzMn0D7_4LLlExhQfaXPMQG70N1Oemi-pzJm28dooMS-6RVc0siTnJw7iB4Vemj6oC8tQ6OH2TomfzUG3uJeSfPiP4ANjyUsnz1izQnZ090ri4RfnsZ2dxsSt7Q88jQpdg-da15GvXjtQkPwbJSvyTQuAzxD8jB3b7VaBkeU82-ID97zjWiCxpAos2JLs9PHco6p_FpA_og_gOCdyqO4zy7ISQNLcQKcGUvsoMh0rkLpyKxFCe97UQ6G-DZaWYRMeXmrvU3aejCot0_hYuGKqMUQ_awhyXAkhG877L9YGeePf3WzWU9i_pOZSGu2zKaiSbuZ80Ir3RbHCswjqMNcN8P_JaudJ6mcN2qY6PwshMYZu4gkkQS-a8dvizw5vp61ltm-D4Tp4lNQi6hU7olYCZaWoBkkBAszFQBXze7JWrnjYWljyacny=s64"}],"mime_type":"application/vnd.google-apps.spreadsheet"}},"provider":"google_drive","type":"file"}}}},"stop_1":{"type":"stop","logging_enabled":false,"x":2057,"y":728}},"edges":["google_sheets_fetch_table_rows_v3_1.rows:map_table_rows_1.rows","google_sheets_fetch_table_row_mapping_1.fetched:map_table_rows_1.map","unmap_table_rows_1.unmapped:google_sheets_update_table_rows_v2_1.update","google_sheets_fetch_table_rows_v3_1.fetched:google_sheets_fetch_table_row_mapping_1.fetch","patch_json_list_v2_1.data_list:unmap_table_rows_1.mapped_rows","unmap_table_rows_1.rows:google_sheets_update_table_rows_v2_1.rows","start_1.start:google_sheets_fetch_table_rows_v3_1.fetch","patch_json_list_v2_1.patched:unmap_table_rows_1.unmap","map_table_rows_1.mapped_rows:patch_json_list_v2_1.data_list","google_sheets_fetch_table_row_mapping_1.mapping:map_table_rows_1.mapping","map_table_rows_1.mapped:patch_json_list_v2_1.patch","google_sheets_fetch_table_row_mapping_1.mapping:unmap_table_rows_1.mapping","google_sheets_update_table_rows_v2_1.updated:stop_1.stop"],"groups":{},"widgets":{},"variables":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}In the example above, I used this spreadsheet.
Additionally if you are looking to send data back into the same sheet, check out this advanced tutorial.
Did this answer your question?
😞
😐
🤩
Last updated on February 28, 2023