Hello. When creating a google form, and responses go into google sheet. Can that response be automated to upload into another application? Trying to eliminate waste of manually entering in another application. Thanks!

like
Posting as :
works at
You are currently posting as works at

You can do that easily if you generate a link to share the Google sheets (generated by the forms), and use the get data functionality (from web) to convert it into an external connection in excel

That requires you to share the Google sheets with everyone WHO HAS THE LINK, which means for some data, this creates a potential risk. Up to you to evaluate if that's acceptable or not

like

Great! Thank you. I’ll look into.

You can convert a Google Sheet into other formats. So that could offer a possibility. You wouldn't have to re-enter the data, at least. But it all depends on what format or app you're trying to get to. There are also third-party products, like Zapier, that can convert things for you.

like

Thank you! It’s a 3rd party application, which my external process partners don’t have. So now i’m asked 😒🤦🏽‍♀️ to create a google form for them. When I receive the responses I’ll have to copy & paste into the application. So i’m looking to see if the response sheet that collects the information would be able to link to the application and up load the info.

I hope this makes sense

Related Posts

What are ways to deal with high latency mricroservice in a given region. Given that it's Cpu utilization is not exhausted.. So no vertical scaling ???

Make body transformation possible at 31? Used to be athletic, now drink a 6 pack and say ready to party.

like

Has anyone done an online DrPh while working full time? If so- was it manageable? Would love to chat with you about your experience :)

like

Guys, what's the salary range for senior manager in PWC SDC with 11 years of BA experience? PWC SDC

like

Walmart vs Morgan Stanley
I have got an opportunity to work at Walmart Global Tech Bengaluru as a SDE-III for their pharma team. I am only concerned with work life balance at Walmart. Should I consider this offer or stay at Morgan Stanley ? Please suggest.

like

Does anyone know a discount code for Omni Hotels?

Any thoughts on the best certifications to get in order to help move forward? I have considered the CCP from World at Work, but it’s fairly pricey to get by the time you wrap up everything. I was looking at both SHRM-CP and SPHR. Everyone that I have spoken to has the SHRM, but that’s also only looking at individuals in a small geographic footprint and within 3-4 different companies. I was hoping to get some thoughts on this from others? Thanks

Anyone working/starting on a side hustle and wants an accountability buddy/cheerleader going into the new year? I’d love one and thought this might be a good place to find one.

like

Holys*it, the seller accepted my offer, i’ll be owning a condo. Surreal! Did i make the right decision in this environment??? 😱

like

Debating between a few travel cards and need some opinions. Debating between Capital One Venture, Venture X and Amex Green card.

Live in a non major city with an international airport, but need to be flexible to different airlines. Which of those cards, or other cards out there, would be best

I’ve been approved for a transfer to the AUS office. Early 30s couple, no kids, small dog. Wife will work for the state but doesn’t have an office assigned yet. Looking for a SFH (that isn’t soullessly modern) in the 600-700k range that will suit our interests: walk to a grocery store, maybe a restaurant or two, commute to work in <30 min. Where should we look?

Any single nyc men ages 32-49 interested in dining with me at one of these phenomenal restaurants, once they open back up? F/39
Chikarashi Isso, Atera, Jungsik, Wayan, Atomix or Eleven Madison.

likefunny

Hi all,
Need likes to start chatting with individuals in group

likehelpful

Hi fishes, I have got an offer from HCL State street as part of reconciliation team. Please tell me about how the WLB is and how good is the growth inside the company?

like

Can folks share their experiences of working during 2nd and 3rd trimesters? How hard was it? What accommodations or adjustments did you make? I’m only in my 1st trimester now but will be starting a new job in October (4 months before my due date) and am nervous about not being able to be at my best

I received offer a month ago n PES started at the same time
How long does it take for PES to complete..
Where can I check the status.....or how long be notifies
What is the process post PES.....
Please someone clarify who has joined recently

like

Anyone have experience salvaging a marriage with an extreme narcissist? I gave it everything I had for a year but thinking it’s time to call it quits.

likeupliftinghelpful
like

Additional Posts in Excel Genius

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

Everyone: Excel is a smart app
Excel:

Post Photo
likefunny

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

Would anyone be willing to teach me vlookup?

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal