Hi. I am trying to have timesheet data feed to Google Sheets. I used a Jotform timesheet template, and the timesheet data is all in one field, but I am having difficulty getting the individual items isolated to map to the Google Sheet. All the timesheet data is one large array(?), but I cannot get it to split up. I have tried iterators, aggregators, and tools, with the help of ChatGPT but cannot get any sense out of it.
What am I doing wrong? I feel it should be a simple answer, but I am not seeing it.
Hello! Welcome to the Make community!
Can you show us what this array looks like, as well as the columns of your google spreadsheet?
Cheers.
Benjamin
1 Like
To link a JotForm timesheet to Google Sheets, you can automate the process using the Make platform by setting up a scenario that integrates JotForm and Google Sheets modules. Here’s a step-by-step breakdown on how to accomplish this:
- Set Up the JotForm Watch for Submissions Module:
• Use the “Watch for Submissions” trigger to detect new submissions on your JotForm. When a user submits the form, this module collects the data from the form.
• In your scenario, make sure that the fields you want to map from JotForm (e.g., time entries, names) are correctly set up to flow into Google Sheets .
- Create Google Sheets Add Row Module:
• After receiving the submission data from JotForm, set up a module in the Make scenario that adds a new row to your Google Sheets. The data from the form, such as the timesheet information, can be directly mapped to the relevant columns in your Google Sheets .
- Test the Automation:
• Submit a few test entries in JotForm to check if they are accurately being reflected in Google Sheets. If your Google Sheets isn’t updating, ensure that the module connections (e.g., JotForm webhook or Google Sheets connection) are correctly set up .
Expanding This Automation:
You can further expand this scenario by adding conditional logic or additional modules. For example:
• Send Notification Emails: After adding the data to Google Sheets, use a module to send an automatic email notification.
• File Upload Handling: If your timesheet form includes file uploads, you can map the file upload URL into your Google Sheets using the correct mapping setup .
Feel free to reach out to me directly if you or someone else needs help in setting up or troubleshooting this automation. I’d be happy to assist!
Yeah that sounds easy, and that is exactly what I did. Trouble is, it doesn’t work. The timesheet data does not come through as available fields, (I copied the timesheet template from Jotforms templates).
Hello @MareeW ,
ok, the format Jotform sent is very special. What you need to do is to use a “JSON/Parse JSON” module. And you need to get the text from the 2nd index of “typeA33”. The index 1 is a string that gives the type “TimeSheet”, and the second index is the actual data, in a raw format.
I simulated the information you get from your screenshot and from what I know about Jotform.
Here is what it should look like
with the “get” function, you are extracting the second index of the typeA33 field. Then you parse it.
Here is an example of output
Benjamin