Gönderim verileri Google E-Tablolar'a nasıl gönderilir?

Selamlar

Biz jotform formlarını satış formları olarak kullanıyoruz. Birçok farklı formumuz var. Bu farklı formlara gelen satışların tamamını, satışların tutarlarını da içerek şekilde, anlık olarak tek bir Google sheets içerisine aktararak takip etmek istiyorum.

Bununla ilgili yardımcı olur musunuz lütfen?

Hi Adam,

Thanks for reaching out to Jotform Support. Unfortunately, our Turkish Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Turkish, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

As for your issue, you can integrate your form with Google Sheets to automatically add your submission data to your spreadsheet. Let me show you how to do it:

1. In Form Builder, click on Settings in the orange navigation bar at the top of the screen.
2. In the menu that opens on the left side of the page, click on Integrations.
3. Click on Google Sheets.

4. You can choose if you want to Create New Spreadsheet or Use Existing Spreadsheet.
5. Click on Next.

6. Click on Authenticate and connect your Google Sheets account.

7. Enter your spreadsheet name.
8. Enter your worksheet name.
9. Select the data you want to send.
10. Tick the checkbox for Send Existing Submissions to the Sheet if you want to send your existing data to your spreadsheet.
11. Click on Save.

That's it. Let us know if you have any other questions.

Hi

I sent them to Google Sheets thank you,

But there is a problem. They are in separated/different worksheets in the spreadsheet. I want them all in a single worksheet. How can I do this?

Hi Adam,

Can you explain a bit more about the issue that they are in separated/different worksheets in the spreadsheet instead of a single sheet? If you can take a screenshot of what’s happening, that'll help us to understand better what’s going on. Let me show you how to post a screenshot to our Support Forum:

1. On the Support Forum page, scroll down to the Your Answer section and click on the Image icon.

2. Drag and drop your image into the Upload box, or click on it and select your file.

3. Then, click on the Add button in the bottom-right corner of the window.

4. To resize it, click on your screenshot and then click on one of the boxes in the corners, and drag it inward.

5. Once you're finished, click on the Post Answer button at the bottom right of the Your Answer section.

That's it. Once we hear back from you, we'll be able to help you with this.