# Copy Spreadsheet ID → Map Form and JSON data **URL:** \ **Category:** Questions\ **Tags:** google-drive, chatgpt, google-sheets, json, mapping\ **Created:** [February 23, 2025, 6:59pm UTC](https://community.make.com/t/copy-spreadsheet-id-map-form-and-json-data/71152 "2025-02-23T18:59:07Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![MaxW](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/maxw/32/57130_2.png) [@MaxW](https://community.make.com/u/MaxW)\ **Post date:** [February 23, 2025, 6:59pm UTC](https://community.make.com/t/copy-spreadsheet-id-map-form-and-json-data/71152/1 "2025-02-23T18:59:07Z")
In this scenario, I want to map the JSON data to the google spreadsheet. ![Screen Shot 2025-02-24 at 7.45.32 AM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/e/dea9b834db66b30e8289bf14319bd6613eaf6b09.png) My thoughts was to use the Drive module to copy an existing spreadsheet ID (since they are the same each time). Then map the JSON data to that same sheet. The google sheet has 4 sheets, 1. The first sheet will map the form submission details. 2. The second sheet will map the JSON data from the ChatGPT module. Once I copy sheet, how would I be able to essentially start mapping to that sheet? I’m stuck at this point and not sure how to access the new spreadsheet to input the data. Form submissions to map to first sheet: ![Screen Shot 2025-02-24 at 7.53.02 AM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/4/6/464ccd912b7c0958c78fc7a7752f55fa71099eaf.png) Google sheet columns to map to second sheet (second row): ![Screen Shot 2025-02-24 at 7.53.21 AM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/4/14b44c6bdafe735d94124a44b63f28692b2c6fe7.png) ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [February 24, 2025, 2:02am UTC](https://community.make.com/t/copy-spreadsheet-id-map-form-and-json-data/71152/2 "2025-02-24T02:02:29Z")
Welcome to the Make community! I would suggest completing the **Make Academy** before jumping into building this complex scenario. If you need **specific assistance** when you are **building a scenario** it’s easier to help you then. Otherwise, you can also **hire a professional** by posting a request in the #Hire a Pro category. Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too — ### Getting Started - [Help Centre](https://www.make.com/en/help) | [Tutorials](https://www.make.com/en/help/tutorials.html) – Make “Manual” - [Make Academy](https://academy.make.com) – Basics 101: Learn Make and get certified ### Help Centre Basics - [Mapping](https://www.make.com/en/help/mapping/mapping) – What is mapping? What can I map? - [Mapping with arrays](https://www.make.com/en/help/mapping/mapping-arrays) – How to map items in an array - [Aggregate an array for mapping complex fields](https://www.make.com/en/help/tools/flow-control#customizing-the-output) - **Date Format** : [tokens for `parseDate`](https://www.make.com/en/help/functions/tokens-for-date-time-parsing) | [tokens for `formatDate`](https://www.make.com/en/help/functions/tokens-for-date-time-formatting) - [HTTP modules](https://www.make.com/en/help/tools/http) – Make a request, Get (download) a file - [Webhooks](https://www.make.com/en/help/tools/webhooks) – Error Handling, Responding to webhooks ### Articles & Videos - [Router Magic Formula](https://www.youtube.com/watch?v=4Q-5BsCtJu4) - YouTube - [Error Handlers in Make](https://www.youtube.com/playlist?list=PLRE9E-rAD8U10mx2TRs54Nq1XJDdK9Kx4) - YouTube playlist - [Getting started with OpenAI](https://community.make.com/t/getting-started-with-openai-gpt-3-and-make/7796) - How to setup and use OpenAI (ChatGPT) in Make - [How to use Regex in Make](https://community.make.com/t/how-to-use-regex-in-make/202) - How to use pattern matching to extract the text you want - [Webhooks – Make Academy](https://academy.make.com/courses/IntermediateC04) – tutorial on how to use Webhooks Hope this helps! Let me know if there are any further questions or issues. — @samliew P.S.: Investing some effort into the [Make Academy](https://academy.make.com) will save you lots of time and frustration using Make. ---
**Author:** ![MaxW](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/maxw/32/57130_2.png) [@MaxW](https://community.make.com/u/MaxW)\ **Post date:** [February 24, 2025, 4:36am UTC](https://community.make.com/t/copy-spreadsheet-id-map-form-and-json-data/71152/3 "2025-02-24T04:36:04Z")
Hey there, I dont have an official working prototype at the moment, since this was a demo concept I am proposing to the client. My question at the moment is should I be duplicating their existing spreadsheet template, and then populating with the output data? I had someone mention I should use the create template module, but that won’t include all the styles they have added to their spreadsheet e.g header bg colours, column widths etc. ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [May 25, 2025, 3:42am UTC](https://community.make.com/t/copy-spreadsheet-id-map-form-and-json-data/71152/4 "2025-05-25T03:42:31Z")